home *** CD-ROM | disk | FTP | other *** search
| Unknown | 1999-03-16 | 24.8 KB |
open in: 
MacOS 8.1
|
Win98
|
DOS
view JSON data
|
view as text
This file was not able to be converted.
This format is not currently supported by dexvert.
| Confidence | Program | Detection | Match Type | Support
|
|---|
| 1%
| dexvert
| ChemDraw Template (other/chemDrawTemplate)
| ext
| Unsupported |
| 100%
| file
| data
| default
| |
| 100%
| TrID
| TERSE compressed data (PACK, U)
| default (weak)
|
|
hex view+--------+-------------------------+-------------------------+--------+--------+
|00000000| 02 00 00 00 03 00 ff ff | 00 00 17 00 78 78 43 6f |........|....xxCo|
|00000010| 6e 74 72 61 63 74 53 75 | 70 70 6f 72 74 53 63 72 |ntractSu|pportScr|
|00000020| 69 70 74 02 00 00 00 11 | 55 52 4c 20 45 73 63 61 |ipt.....|URL Esca|
|00000030| 70 65 20 53 70 61 63 65 | 73 ff 69 01 2f 2f 20 54 |pe Space|s.i.// T|
|00000040| 68 69 73 20 66 75 6e 63 | 74 69 6f 6e 20 72 65 70 |his func|tion rep|
|00000050| 6c 61 63 65 73 20 61 6c | 6c 20 74 68 65 20 73 70 |laces al|l the sp|
|00000060| 61 63 65 73 20 69 6e 20 | 74 68 65 20 0d 0a 2f 2f |aces in |the ..//|
|00000070| 20 69 6e 20 73 74 72 69 | 6e 67 20 77 69 74 68 20 | in stri|ng with |
|00000080| 25 32 30 2e 20 20 46 6f | 72 20 75 73 65 20 77 69 |%20. Fo|r use wi|
|00000090| 74 68 20 55 52 4c 20 73 | 74 72 69 6e 67 73 2e 0d |th URL s|trings..|
|000000a0| 0a 66 75 6e 63 74 69 6f | 6e 20 55 52 4c 45 73 63 |.functio|n URLEsc|
|000000b0| 61 70 65 53 70 61 63 65 | 73 28 73 74 72 49 6e 29 |apeSpace|s(strIn)|
|000000c0| 0d 0a 7b 0d 0a 0d 0a 09 | 76 61 72 20 61 20 3d 20 |..{.....|var a = |
|000000d0| 22 20 22 0d 0a 09 76 61 | 72 20 62 20 3d 20 22 25 |" "...va|r b = "%|
|000000e0| 32 30 22 0d 0a 09 76 61 | 72 20 63 20 3d 20 73 74 |20"...va|r c = st|
|000000f0| 72 49 6e 0d 0a 0d 0a 09 | 76 61 72 20 69 20 3d 20 |rIn.....|var i = |
|00000100| 63 2e 69 6e 64 65 78 4f | 66 28 61 29 3b 0d 0a 09 |c.indexO|f(a);...|
|00000110| 76 61 72 20 6c 20 3d 20 | 62 2e 6c 65 6e 67 74 68 |var l = |b.length|
|00000120| 3b 0d 0a 0d 0a 09 77 68 | 69 6c 65 20 28 69 20 21 |;.....wh|ile (i !|
|00000130| 3d 20 2d 31 29 09 7b 0d | 0a 09 09 63 20 3d 20 63 |= -1).{.|...c = c|
|00000140| 2e 73 75 62 73 74 72 69 | 6e 67 28 30 2c 69 29 20 |.substri|ng(0,i) |
|00000150| 2b 20 62 20 2b 20 63 2e | 73 75 62 73 74 72 69 6e |+ b + c.|substrin|
|00000160| 67 28 69 20 2b 20 61 2e | 6c 65 6e 67 74 68 2c 63 |g(i + a.|length,c|
|00000170| 2e 6c 65 6e 67 74 68 29 | 3b 0d 0a 09 09 69 20 3d |.length)|;....i =|
|00000180| 20 63 2e 69 6e 64 65 78 | 4f 66 28 61 2c 69 29 3b | c.index|Of(a,i);|
|00000190| 0d 0a 09 7d 0d 0a 09 72 | 65 74 75 72 6e 20 63 3b |...}...r|eturn c;|
|000001a0| 0d 0a 0d 0a 7d e0 5a 9c | 93 23 83 d2 11 80 52 00 |....}.Z.|.#....R.|
|000001b0| 10 4b d3 38 d1 01 80 02 | 00 00 00 07 67 65 74 46 |.K.8....|....getF|
|000001c0| 6f 72 6d ff 31 03 66 75 | 6e 63 74 69 6f 6e 20 67 |orm.1.fu|nction g|
|000001d0| 65 74 46 6f 72 6d 28 29 | 0d 0a 7b 0d 0a 09 76 61 |etForm()|..{...va|
|000001e0| 72 20 66 3b 0d 0a 09 69 | 66 20 28 64 6f 63 75 6d |r f;...i|f (docum|
|000001f0| 65 6e 74 2e 66 6f 72 6d | 73 20 26 26 20 64 6f 63 |ent.form|s && doc|
|00000200| 75 6d 65 6e 74 2e 66 6f | 72 6d 73 5b 30 5d 29 0d |ument.fo|rms[0]).|
|00000210| 0a 09 7b 0d 0a 09 09 2f | 2f 20 54 68 69 73 20 69 |..{..../|/ This i|
|00000220| 73 20 74 68 65 20 63 61 | 73 65 20 77 68 65 72 65 |s the ca|se where|
|00000230| 20 74 68 65 72 65 20 61 | 72 65 20 6f 6e 6c 79 20 | there a|re only |
|00000240| 68 69 64 64 65 6e 20 66 | 6f 72 6d 20 65 6c 65 6d |hidden f|orm elem|
|00000250| 65 6e 74 73 20 69 6e 20 | 61 6e 0d 0a 09 09 2f 2f |ents in |an....//|
|00000260| 20 61 6c 6c 20 34 2e 30 | 20 62 72 6f 77 73 65 72 | all 4.0| browser|
|00000270| 20 70 61 67 65 20 61 6e | 64 20 43 6f 6d 6d 20 69 | page an|d Comm i|
|00000280| 73 20 68 69 74 74 69 6e | 67 20 74 68 65 20 70 61 |s hittin|g the pa|
|00000290| 67 65 20 2d 20 61 6e 64 | 20 61 6c 6c 20 49 45 20 |ge - and| all IE |
|000002a0| 63 61 73 65 73 2e 0d 0a | 09 09 66 20 3d 20 64 6f |cases...|..f = do|
|000002b0| 63 75 6d 65 6e 74 2e 66 | 6f 72 6d 73 5b 30 5d 3b |cument.f|orms[0];|
|000002c0| 0d 0a 09 7d 0d 0a 0d 0a | 09 69 66 20 28 66 20 3d |...}....|.if (f =|
|000002d0| 3d 20 6e 75 6c 6c 29 0d | 0a 09 7b 0d 0a 09 09 69 |= null).|..{....i|
|000002e0| 66 20 28 28 64 6f 63 75 | 6d 65 6e 74 2e 6c 61 79 |f ((docu|ment.lay|
|000002f0| 65 72 73 29 20 26 26 20 | 28 64 6f 63 75 6d 65 6e |ers) && |(documen|
|00000300| 74 2e 6c 61 79 65 72 73 | 2e 6c 65 6e 67 74 68 20 |t.layers|.length |
|00000310| 3e 20 30 29 29 0d 0a 09 | 09 7b 0d 0a 09 09 09 76 |> 0))...|.{.....v|
|00000320| 61 72 20 64 3b 0d 0a 09 | 09 09 69 4c 61 79 65 72 |ar d;...|..iLayer|
|00000330| 20 3d 20 30 3b 0d 0a 09 | 09 09 77 68 69 6c 65 20 | = 0;...|..while |
|00000340| 28 74 72 75 65 29 0d 0a | 09 09 09 7b 0d 0a 09 09 |(true)..|...{....|
|00000350| 09 09 64 20 3d 20 64 6f | 63 75 6d 65 6e 74 2e 6c |..d = do|cument.l|
|00000360| 61 79 65 72 73 5b 69 4c | 61 79 65 72 5d 2e 64 6f |ayers[iL|ayer].do|
|00000370| 63 75 6d 65 6e 74 2e 6c | 61 79 65 72 73 5b 30 5d |cument.l|ayers[0]|
|00000380| 2e 64 6f 63 75 6d 65 6e | 74 3b 0d 0a 09 09 09 09 |.documen|t;......|
|00000390| 69 66 20 28 64 2e 66 6f | 72 6d 73 20 26 26 20 64 |if (d.fo|rms && d|
|000003a0| 2e 66 6f 72 6d 73 5b 30 | 5d 29 20 2f 2f 20 6e 6f |.forms[0|]) // no|
|000003b0| 72 6d 61 6c 20 63 61 73 | 65 0d 0a 09 09 09 09 7b |rmal cas|e......{|
|000003c0| 0d 0a 09 09 09 09 09 66 | 20 3d 20 64 2e 66 6f 72 |.......f| = d.for|
|000003d0| 6d 73 5b 30 5d 3b 0d 0a | 09 09 09 09 09 62 72 65 |ms[0];..|.....bre|
|000003e0| 61 6b 3b 0d 0a 09 09 09 | 09 7d 0d 0a 09 09 09 09 |ak;.....|.}......|
|000003f0| 69 4c 61 79 65 72 20 3d | 20 69 4c 61 79 65 72 20 |iLayer =| iLayer |
|00000400| 2b 20 32 3b 0d 0a 09 09 | 09 0d 0a 09 09 09 09 69 |+ 2;....|.......i|
|00000410| 66 20 28 64 6f 63 75 6d | 65 6e 74 2e 6c 61 79 65 |f (docum|ent.laye|
|00000420| 72 73 5b 69 4c 61 79 65 | 72 5d 20 3d 3d 20 6e 75 |rs[iLaye|r] == nu|
|00000430| 6c 6c 29 0d 0a 09 09 09 | 09 09 62 72 65 61 6b 3b |ll).....|..break;|
|00000440| 0d 0a 09 09 09 7d 0d 0a | 09 09 7d 0d 0a 09 7d 0d |.....}..|..}...}.|
|00000450| 0a 0d 0a 09 69 66 20 28 | 66 20 3d 3d 20 6e 75 6c |....if (|f == nul|
|00000460| 6c 29 0d 0a 09 09 61 6c | 65 72 74 28 22 46 6f 72 |l)....al|ert("For|
|00000470| 6d 20 6e 6f 74 20 73 75 | 62 6d 69 74 74 65 64 20 |m not su|bmitted |
|00000480| 2d 20 69 6e 74 65 72 6e | 61 6c 20 65 72 72 6f 72 |- intern|al error|
|00000490| 3a 20 44 72 75 6d 62 65 | 61 74 20 63 61 6e 20 6e |: Drumbe|at can n|
|000004a0| 6f 74 20 66 69 6e 64 20 | 46 6f 72 6d 20 6f 62 6a |ot find |Form obj|
|000004b0| 65 63 74 20 69 6e 20 44 | 4f 4d 2e 20 54 68 65 72 |ect in D|OM. Ther|
|000004c0| 65 20 6d 61 79 20 6e 6f | 74 20 62 65 20 61 20 66 |e may no|t be a f|
|000004d0| 6f 72 6d 20 6f 6e 20 74 | 68 69 73 20 70 61 67 65 |orm on t|his page|
|000004e0| 2e 22 29 3b 0d 0a 0d 0a | 09 72 65 74 75 72 6e 20 |.");....|.return |
|000004f0| 66 3b 0d 0a 7d 0d 0a eb | 45 94 79 c0 7f d2 11 b8 |f;..}...|E.y.....|
|00000500| 68 00 60 08 3e 34 a5 01 | 80 02 00 00 00 11 53 75 |h.`.>4..|......Su|
|00000510| 62 20 41 20 77 69 74 68 | 20 42 20 69 6e 20 43 d1 |b A with| B in C.|
|00000520| 66 75 6e 63 74 69 6f 6e | 20 73 75 62 41 77 69 74 |function| subAwit|
|00000530| 68 42 69 6e 43 28 61 2c | 62 2c 63 29 0d 0a 7b 0d |hBinC(a,|b,c)..{.|
|00000540| 0a 0d 0a 09 76 61 72 20 | 69 20 3d 20 63 2e 69 6e |....var |i = c.in|
|00000550| 64 65 78 4f 66 28 61 29 | 3b 0d 0a 09 76 61 72 20 |dexOf(a)|;...var |
|00000560| 6c 20 3d 20 62 2e 6c 65 | 6e 67 74 68 3b 0d 0a 0d |l = b.le|ngth;...|
|00000570| 0a 09 77 68 69 6c 65 20 | 28 69 20 21 3d 20 2d 31 |..while |(i != -1|
|00000580| 29 09 7b 0d 0a 09 09 63 | 20 3d 20 63 2e 73 75 62 |).{....c| = c.sub|
|00000590| 73 74 72 69 6e 67 28 30 | 2c 69 29 20 2b 20 62 20 |string(0|,i) + b |
|000005a0| 2b 20 63 2e 73 75 62 73 | 74 72 69 6e 67 28 69 20 |+ c.subs|tring(i |
|000005b0| 2b 20 61 2e 6c 65 6e 67 | 74 68 2c 63 2e 6c 65 6e |+ a.leng|th,c.len|
|000005c0| 67 74 68 29 3b 0d 0a 09 | 09 69 20 3d 20 63 2e 69 |gth);...|.i = c.i|
|000005d0| 6e 64 65 78 4f 66 28 61 | 2c 69 29 3b 0d 0a 09 7d |ndexOf(a|,i);...}|
|000005e0| 0d 0a 09 72 65 74 75 72 | 6e 20 63 3b 0d 0a 0d 0a |...retur|n c;....|
|000005f0| 7d 0f 2a 65 12 28 83 d2 | 11 80 52 00 10 4b d3 38 |}.*e.(..|..R..K.8|
|00000600| d1 0f 00 ff ff 00 00 0a | 00 78 78 43 6f 6e 74 72 |........|.xxContr|
|00000610| 61 63 74 12 00 00 00 3b | 47 6f 20 74 6f 20 74 68 |act....;|Go to th|
|00000620| 65 20 66 69 72 73 74 20 | 72 65 63 6f 72 64 20 69 |e first |record i|
|00000630| 6e 20 5b 74 61 72 67 65 | 74 5d 20 77 68 65 6e 20 |n [targe|t] when |
|00000640| 5b 73 6f 75 72 63 65 5d | 20 69 73 20 63 6c 69 63 |[source]| is clic|
|00000650| 6b 65 64 00 00 00 00 00 | 02 00 ff ff 00 00 15 00 |ked.....|........|
|00000660| 78 78 43 6f 6e 74 72 61 | 63 74 50 61 72 74 69 63 |xxContra|ctPartic|
|00000670| 69 70 61 6e 74 01 00 00 | 00 06 53 6f 75 72 63 65 |ipant...|..Source|
|00000680| 01 00 ff ff 00 00 15 00 | 78 78 43 6f 6e 74 72 61 |........|xxContra|
|00000690| 63 74 52 65 71 75 69 72 | 65 6d 65 6e 74 03 00 00 |ctRequir|ement...|
|000006a0| 00 00 00 00 00 07 6f 6e | 43 6c 69 63 6b 01 00 ff |......on|Click...|
|000006b0| ff 00 00 10 00 78 78 43 | 6f 6e 74 72 61 63 74 41 |.....xxC|ontractA|
|000006c0| 63 74 69 6f 6e 04 00 00 | 00 07 6f 6e 43 6c 69 63 |ction...|..onClic|
|000006d0| 6b 01 00 00 00 00 00 00 | 00 00 07 80 01 00 00 00 |k.......|........|
|000006e0| 06 54 61 72 67 65 74 02 | 00 09 80 03 00 00 00 01 |.Target.|........|
|000006f0| 00 00 00 0b 4d 6f 76 65 | 46 69 72 73 74 28 29 09 |....Move|First().|
|00000700| 80 03 00 00 00 00 00 00 | 00 0c 42 65 66 6f 72 65 |........|..Before|
|00000710| 4f 70 65 6e 28 29 01 00 | 0b 80 04 00 00 00 0c 42 |Open()..|.......B|
|00000720| 65 66 6f 72 65 4f 70 65 | 6e 28 29 02 00 00 00 00 |eforeOpe|n().....|
|00000730| 00 00 00 50 69 66 20 28 | 52 65 71 75 65 73 74 2e |...Pif (|Request.|
|00000740| 46 6f 72 6d 2e 4b 65 79 | 28 22 5b 53 6f 75 72 63 |Form.Key|("[Sourc|
|00000750| 65 5d 22 29 20 21 3d 20 | 22 22 29 20 0d 0a 7b 0d |e]") != |"") ..{.|
|00000760| 0a 20 20 20 20 5b 54 61 | 72 67 65 74 5d 2e 53 65 |. [Ta|rget].Se|
|00000770| 74 41 63 74 69 6f 6e 28 | 22 46 69 72 73 74 22 29 |tAction(|"First")|
|00000780| 3b 0d 0a 7d 01 00 00 00 | 53 69 66 20 52 65 71 75 |;..}....|Sif Requ|
|00000790| 65 73 74 2e 46 6f 72 6d | 2e 4b 65 79 28 22 5b 53 |est.Form|.Key("[S|
|000007a0| 6f 75 72 63 65 5d 22 29 | 20 3c 3e 20 22 22 20 54 |ource]")| <> "" T|
|000007b0| 68 65 6e 0d 0a 20 20 20 | 20 5b 54 61 72 67 65 74 |hen.. | [Target|
|000007c0| 5d 2e 53 65 74 41 63 74 | 69 6f 6e 28 22 46 69 72 |].SetAct|ion("Fir|
|000007d0| 73 74 22 29 0d 0a 65 6e | 64 20 69 66 00 00 13 44 |st")..en|d if...D|
|000007e0| 61 74 61 62 61 73 65 20 | 6e 61 76 69 67 61 74 69 |atabase |navigati|
|000007f0| 6f 6e 00 00 00 00 00 00 | 04 00 00 00 01 00 00 00 |on......|........|
|00000800| 03 00 0b 80 04 00 00 00 | 06 53 65 72 76 65 72 02 |........|.Server.|
|00000810| 00 00 00 00 00 00 00 00 | 01 00 00 00 00 0b 80 04 |........|........|
|00000820| 00 00 00 00 01 00 00 00 | 00 00 00 00 00 0b 80 04 |........|........|
|00000830| 00 00 00 06 6f 6e 42 6c | 75 72 01 00 00 00 00 00 |....onBl|ur......|
|00000840| 00 00 00 79 c2 d3 2a 83 | 16 d2 11 90 80 00 60 08 |...y..*.|......`.|
|00000850| 8f 47 c4 01 00 00 00 24 | 33 37 37 41 43 34 33 30 |.G.....$|377AC430|
|00000860| 2d 36 32 31 31 2d 31 31 | 44 32 2d 38 31 31 37 2d |-6211-11|D2-8117-|
|00000870| 30 30 36 30 30 38 43 38 | 36 43 32 35 03 33 2e 30 |006008C8|6C25.3.0|
|00000880| ff b3 01 56 31 30 5f 33 | 30 0d 0a 0d 0a 4e 6f 74 |...V10_3|0....Not|
|00000890| 65 3a 20 74 68 69 73 20 | 63 6f 6e 74 72 61 63 74 |e: this |contract|
|000008a0| 20 69 73 20 75 73 65 64 | 20 62 79 20 74 68 65 20 | is used| by the |
|000008b0| 44 61 74 61 46 6f 72 6d | 20 57 69 7a 61 72 64 2c |DataForm| Wizard,|
|000008c0| 20 6d 6f 64 69 66 69 63 | 61 74 69 6f 6e 73 20 61 | modific|ations a|
|000008d0| 72 65 20 6e 6f 74 20 72 | 65 63 6f 6d 6d 65 6e 64 |re not r|ecommend|
|000008e0| 65 64 2e 20 20 49 66 20 | 79 6f 75 20 77 6f 75 6c |ed. If |you woul|
|000008f0| 64 20 6c 69 6b 65 20 74 | 6f 20 6d 6f 64 69 66 79 |d like t|o modify|
|00000900| 20 69 74 2c 20 63 72 65 | 61 74 65 20 61 6e 64 20 | it, cre|ate and |
|00000910| 6d 6f 64 69 66 79 20 61 | 20 63 6f 70 79 20 74 6f |modify a| copy to|
|00000920| 20 72 65 74 61 69 6e 20 | 74 68 65 20 6f 72 69 67 | retain |the orig|
|00000930| 69 6e 61 6c 2e 0d 0a 0d | 0a 54 68 69 73 20 63 6f |inal....|.This co|
|00000940| 6e 74 72 61 63 74 20 69 | 73 20 61 6e 20 69 6e 74 |ntract i|s an int|
|00000950| 65 72 61 63 74 69 6f 6e | 20 62 65 74 77 65 65 6e |eraction| between|
|00000960| 20 61 20 73 75 62 6d 69 | 74 20 62 75 74 74 6f 6e | a submi|t button|
|00000970| 20 28 73 6f 75 72 63 65 | 29 20 61 6e 64 20 61 20 | (source|) and a |
|00000980| 72 65 63 6f 72 64 73 65 | 74 20 28 74 61 72 67 65 |recordse|t (targe|
|00000990| 74 29 2e 20 20 43 6c 69 | 63 6b 69 6e 67 20 74 68 |t). Cli|cking th|
|000009a0| 65 20 62 75 74 74 6f 6e | 20 6d 6f 76 65 73 20 74 |e button| moves t|
|000009b0| 6f 20 74 68 65 20 66 69 | 72 73 74 20 72 65 63 6f |o the fi|rst reco|
|000009c0| 72 64 20 6f 66 20 74 68 | 65 20 72 65 63 6f 72 64 |rd of th|e record|
|000009d0| 73 65 74 20 73 6f 75 72 | 63 65 2e 0d 0a 0d 0a 53 |set sour|ce.....S|
|000009e0| 65 65 20 44 61 74 61 62 | 61 73 65 4e 61 76 69 67 |ee Datab|aseNavig|
|000009f0| 61 74 69 6f 6e 2e 64 6f | 63 20 66 6f 72 20 67 65 |ation.do|c for ge|
|00000a00| 6e 65 72 61 6c 20 69 6e | 66 6f 72 6d 61 74 69 6f |neral in|formatio|
|00000a10| 6e 20 6f 6e 20 44 61 74 | 61 62 61 73 65 20 6e 61 |n on Dat|abase na|
|00000a20| 76 69 67 61 74 69 6f 6e | 20 63 6f 6e 74 72 61 63 |vigation| contrac|
|00000a30| 74 73 2e 20 0d 0a 05 80 | 12 00 00 00 3a 47 6f 20 |ts. ....|....:Go |
|00000a40| 74 6f 20 74 68 65 20 6c | 61 73 74 20 72 65 63 6f |to the l|ast reco|
|00000a50| 72 64 20 69 6e 20 5b 74 | 61 72 67 65 74 5d 20 77 |rd in [t|arget] w|
|00000a60| 68 65 6e 20 5b 73 6f 75 | 72 63 65 5d 20 69 73 20 |hen [sou|rce] is |
|00000a70| 63 6c 69 63 6b 65 64 00 | 00 00 00 00 02 00 07 80 |clicked.|........|
|00000a80| 01 00 00 00 06 53 6f 75 | 72 63 65 01 00 09 80 03 |.....Sou|rce.....|
|00000a90| 00 00 00 00 00 00 00 07 | 6f 6e 43 6c 69 63 6b 01 |........|onClick.|
|00000aa0| 00 0b 80 04 00 00 00 07 | 6f 6e 43 6c 69 63 6b 01 |........|onClick.|
|00000ab0| 00 00 00 00 00 00 00 00 | 07 80 01 00 00 00 06 54 |........|.......T|
|00000ac0| 61 72 67 65 74 02 00 09 | 80 03 00 00 00 01 00 00 |arget...|........|
|00000ad0| 00 0a 4d 6f 76 65 4c 61 | 73 74 28 29 09 80 03 00 |..MoveLa|st()....|
|00000ae0| 00 00 00 00 00 00 0c 42 | 65 66 6f 72 65 4f 70 65 |.......B|eforeOpe|
|00000af0| 6e 28 29 01 00 0b 80 04 | 00 00 00 0c 42 65 66 6f |n().....|....Befo|
|00000b00| 72 65 4f 70 65 6e 28 29 | 02 00 00 00 00 00 00 00 |reOpen()|........|
|00000b10| 4e 69 66 20 28 52 65 71 | 75 65 73 74 2e 46 6f 72 |Nif (Req|uest.For|
|00000b20| 6d 2e 4b 65 79 28 22 5b | 53 6f 75 72 63 65 5d 22 |m.Key("[|Source]"|
|00000b30| 29 20 21 3d 20 22 22 29 | 0d 0a 7b 0d 0a 20 20 20 |) != "")|..{.. |
|00000b40| 20 5b 54 61 72 67 65 74 | 5d 2e 53 65 74 41 63 74 | [Target|].SetAct|
|00000b50| 69 6f 6e 28 22 4c 61 73 | 74 22 29 3b 0d 0a 7d 01 |ion("Las|t");..}.|
|00000b60| 00 00 00 52 69 66 20 52 | 65 71 75 65 73 74 2e 46 |...Rif R|equest.F|
|00000b70| 6f 72 6d 2e 4b 65 79 28 | 22 5b 53 6f 75 72 63 65 |orm.Key(|"[Source|
|00000b80| 5d 22 29 20 3c 3e 20 22 | 22 20 74 68 65 6e 0d 0a |]") <> "|" then..|
|00000b90| 20 20 20 20 5b 54 61 72 | 67 65 74 5d 2e 53 65 74 | [Tar|get].Set|
|00000ba0| 41 63 74 69 6f 6e 28 22 | 4c 61 73 74 22 29 0d 0a |Action("|Last")..|
|00000bb0| 65 6e 64 20 69 66 00 00 | 13 44 61 74 61 62 61 73 |end if..|.Databas|
|00000bc0| 65 20 6e 61 76 69 67 61 | 74 69 6f 6e 00 00 00 00 |e naviga|tion....|
|00000bd0| 00 00 04 00 00 00 01 00 | 00 00 04 00 0b 80 04 00 |........|........|
|00000be0| 00 00 08 6f 6e 55 6e 4c | 6f 61 64 01 00 00 00 00 |...onUnL|oad.....|
|00000bf0| 00 00 00 00 0b 80 04 00 | 00 00 06 53 65 72 76 65 |........|...Serve|
|00000c00| 72 02 00 00 00 00 00 00 | 00 00 01 00 00 00 00 0b |r.......|........|
|00000c10| 80 04 00 00 00 00 01 00 | 00 00 00 00 00 00 00 0b |........|........|
|00000c20| 80 04 00 00 00 06 6f 6e | 42 6c 75 72 01 00 00 00 |......on|Blur....|
|00000c30| 00 00 00 00 00 5b 40 63 | d6 5b 17 d2 11 90 81 00 |.....[@c|.[......|
|00000c40| 60 08 8f 47 c4 01 00 00 | 00 24 33 37 37 41 43 34 |`..G....|.$377AC4|
|00000c50| 33 30 2d 36 32 31 31 2d | 31 31 44 32 2d 38 31 31 |30-6211-|11D2-811|
|00000c60| 37 2d 30 30 36 30 30 38 | 43 38 36 43 32 35 03 33 |7-006008|C86C25.3|
|00000c70| 2e 30 ff af 01 56 31 30 | 5f 33 30 0d 0a 0d 0a 4e |.0...V10|_30....N|
|00000c80| 6f 74 65 3a 20 74 68 69 | 73 20 63 6f 6e 74 72 61 |ote: thi|s contra|
|00000c90| 63 74 20 69 73 20 75 73 | 65 64 20 62 79 20 74 68 |ct is us|ed by th|
|00000ca0| 65 20 44 61 74 61 46 6f | 72 6d 20 57 69 7a 61 72 |e DataFo|rm Wizar|
|00000cb0| 64 2c 20 6d 6f 64 69 66 | 69 63 61 74 69 6f 6e 73 |d, modif|ications|
|00000cc0| 20 61 72 65 20 6e 6f 74 | 20 72 65 63 6f 6d 6d 65 | are not| recomme|
|00000cd0| 6e 64 65 64 2e 20 20 49 | 66 20 79 6f 75 20 77 6f |nded. I|f you wo|
|00000ce0| 75 6c 64 20 6c 69 6b 65 | 20 74 6f 20 6d 6f 64 69 |uld like| to modi|
|00000cf0| 66 79 20 69 74 2c 20 63 | 72 65 61 74 65 20 61 6e |fy it, c|reate an|
|00000d00| 64 20 6d 6f 64 69 66 79 | 20 61 20 63 6f 70 79 20 |d modify| a copy |
|00000d10| 74 6f 20 72 65 74 61 69 | 6e 20 74 68 65 20 6f 72 |to retai|n the or|
|00000d20| 69 67 69 6e 61 6c 2e 0d | 0a 0d 0a 54 68 69 73 20 |iginal..|...This |
|00000d30| 63 6f 6e 74 72 61 63 74 | 20 69 73 20 61 6e 20 69 |contract| is an i|
|00000d40| 6e 74 65 72 61 63 74 69 | 6f 6e 20 62 65 74 77 65 |nteracti|on betwe|
|00000d50| 65 6e 20 61 20 73 75 62 | 6d 69 74 20 62 75 74 74 |en a sub|mit butt|
|00000d60| 6f 6e 20 28 73 6f 75 72 | 63 65 29 20 61 6e 64 20 |on (sour|ce) and |
|00000d70| 61 20 72 65 63 6f 72 64 | 73 65 74 20 28 74 61 72 |a record|set (tar|
|00000d80| 67 65 74 29 2e 20 20 43 | 6c 69 63 6b 69 6e 67 20 |get). C|licking |
|00000d90| 74 68 65 20 62 75 74 74 | 6f 6e 20 6d 6f 76 65 73 |the butt|on moves|
|00000da0| 20 74 6f 20 74 68 65 20 | 6c 61 73 74 20 72 65 63 | to the |last rec|
|00000db0| 6f 72 64 20 6f 66 20 74 | 68 65 20 72 65 63 6f 72 |ord of t|he recor|
|00000dc0| 64 73 65 74 20 73 6f 75 | 72 63 65 2e 0d 0a 0d 0a |dset sou|rce.....|
|00000dd0| 53 65 65 20 44 61 74 61 | 62 61 73 65 4e 61 76 69 |See Data|baseNavi|
|00000de0| 67 61 74 69 6f 6e 2e 64 | 6f 63 20 66 6f 72 20 67 |gation.d|oc for g|
|00000df0| 65 6e 65 72 61 6c 20 69 | 6e 66 6f 72 6d 61 74 69 |eneral i|nformati|
|00000e00| 6f 6e 20 6f 6e 20 44 61 | 74 61 62 61 73 65 20 6e |on on Da|tabase n|
|00000e10| 61 76 69 67 61 74 69 6f | 6e 20 63 6f 6e 74 72 61 |avigatio|n contra|
|00000e20| 63 74 73 2e 05 80 12 00 | 00 00 3e 47 6f 20 74 6f |cts.....|..>Go to|
|00000e30| 20 74 68 65 20 70 72 65 | 76 69 6f 75 73 20 72 65 | the pre|vious re|
|00000e40| 63 6f 72 64 20 69 6e 20 | 5b 74 61 72 67 65 74 5d |cord in |[target]|
|00000e50| 20 77 68 65 6e 20 5b 73 | 6f 75 72 63 65 5d 20 69 | when [s|ource] i|
|00000e60| 73 20 63 6c 69 63 6b 65 | 64 00 00 00 00 00 02 00 |s clicke|d.......|
|00000e70| 07 80 01 00 00 00 06 53 | 6f 75 72 63 65 01 00 09 |.......S|ource...|
|00000e80| 80 03 00 00 00 00 00 00 | 00 07 6f 6e 43 6c 69 63 |........|..onClic|
|00000e90| 6b 01 00 0b 80 04 00 00 | 00 07 6f 6e 43 6c 69 63 |k.......|..onClic|
|00000ea0| 6b 01 00 00 00 00 00 00 | 00 00 07 80 01 00 00 00 |k.......|........|
|00000eb0| 06 54 61 72 67 65 74 02 | 00 09 80 03 00 00 00 01 |.Target.|........|
|00000ec0| 00 00 00 0e 4d 6f 76 65 | 50 72 65 76 69 6f 75 73 |....Move|Previous|
|00000ed0| 28 29 09 80 03 00 00 00 | 00 00 00 00 0c 42 65 66 |()......|.....Bef|
|00000ee0| 6f 72 65 4f 70 65 6e 28 | 29 01 00 0b 80 04 00 00 |oreOpen(|).......|
|00000ef0| 00 0c 42 65 66 6f 72 65 | 4f 70 65 6e 28 29 02 00 |..Before|Open()..|
|00000f00| 00 00 00 00 00 00 53 69 | 66 20 28 52 65 71 75 65 |......Si|f (Reque|
|00000f10| 73 74 2e 46 6f 72 6d 2e | 4b 65 79 28 22 5b 53 6f |st.Form.|Key("[So|
|00000f20| 75 72 63 65 5d 22 29 20 | 21 3d 20 22 22 29 20 0d |urce]") |!= "") .|
|00000f30| 0a 7b 0d 0a 20 20 20 20 | 5b 54 61 72 67 65 74 5d |.{.. |[Target]|
|00000f40| 2e 53 65 74 41 63 74 69 | 6f 6e 28 22 50 72 65 76 |.SetActi|on("Prev|
|00000f50| 69 6f 75 73 22 29 3b 0d | 0a 7d 01 00 00 00 56 69 |ious");.|.}....Vi|
|00000f60| 66 20 52 65 71 75 65 73 | 74 2e 46 6f 72 6d 2e 4b |f Reques|t.Form.K|
|00000f70| 65 79 28 22 5b 53 6f 75 | 72 63 65 5d 22 29 20 3c |ey("[Sou|rce]") <|
|00000f80| 3e 20 22 22 20 54 68 65 | 6e 0d 0a 20 20 20 20 5b |> "" The|n.. [|
|00000f90| 54 61 72 67 65 74 5d 2e | 53 65 74 41 63 74 69 6f |Target].|SetActio|
|00000fa0| 6e 28 22 50 72 65 76 69 | 6f 75 73 22 29 0d 0a 65 |n("Previ|ous")..e|
|00000fb0| 6e 64 20 69 66 00 00 13 | 44 61 74 61 62 61 73 65 |nd if...|Database|
|00000fc0| 20 6e 61 76 69 67 61 74 | 69 6f 6e 00 00 00 00 00 | navigat|ion.....|
|00000fd0| 00 04 00 00 00 01 00 00 | 00 03 00 0b 80 04 00 00 |........|........|
|00000fe0| 00 06 53 65 72 76 65 72 | 02 00 00 00 00 00 00 00 |..Server|........|
|00000ff0| 00 01 00 00 00 00 0b 80 | 04 00 00 00 00 01 00 00 |........|........|
|00001000| 00 00 00 00 00 00 0b 80 | 04 00 00 00 06 6f 6e 42 |........|.....onB|
|00001010| 6c 75 72 01 00 00 00 00 | 00 00 00 00 1a ca d3 2a |lur.....|.......*|
|00001020| 83 16 d2 11 90 80 00 60 | 08 8f 47 c4 01 00 00 00 |.......`|..G.....|
|00001030| 24 33 37 37 41 43 34 33 | 30 2d 36 32 31 31 2d 31 |$377AC43|0-6211-1|
|00001040| 31 44 32 2d 38 31 31 37 | 2d 30 30 36 30 30 38 43 |1D2-8117|-006008C|
|00001050| 38 36 43 32 35 03 33 2e | 30 ff b3 01 56 31 30 5f |86C25.3.|0...V10_|
|00001060| 33 30 0d 0a 0d 0a 4e 6f | 74 65 3a 20 74 68 69 73 |30....No|te: this|
|00001070| 20 63 6f 6e 74 72 61 63 | 74 20 69 73 20 75 73 65 | contrac|t is use|
|00001080| 64 20 62 79 20 74 68 65 | 20 44 61 74 61 46 6f 72 |d by the| DataFor|
|00001090| 6d 20 57 69 7a 61 72 64 | 2c 20 6d 6f 64 69 66 69 |m Wizard|, modifi|
|000010a0| 63 61 74 69 6f 6e 73 20 | 61 72 65 20 6e 6f 74 20 |cations |are not |
|000010b0| 72 65 63 6f 6d 6d 65 6e | 64 65 64 2e 20 20 49 66 |recommen|ded. If|
|000010c0| 20 79 6f 75 20 77 6f 75 | 6c 64 20 6c 69 6b 65 20 | you wou|ld like |
|000010d0| 74 6f 20 6d 6f 64 69 66 | 79 20 69 74 2c 20 63 72 |to modif|y it, cr|
|000010e0| 65 61 74 65 20 61 6e 64 | 20 6d 6f 64 69 66 79 20 |eate and| modify |
|000010f0| 61 20 63 6f 70 79 20 74 | 6f 20 72 65 74 61 69 6e |a copy t|o retain|
|00001100| 20 74 68 65 20 6f 72 69 | 67 69 6e 61 6c 2e 0d 0a | the ori|ginal...|
|00001110| 0d 0a 54 68 69 73 20 63 | 6f 6e 74 72 61 63 74 20 |..This c|ontract |
|00001120| 69 73 20 61 6e 20 69 6e | 74 65 72 61 63 74 69 6f |is an in|teractio|
|00001130| 6e 20 62 65 74 77 65 65 | 6e 20 61 20 73 75 62 6d |n betwee|n a subm|
|00001140| 69 74 20 62 75 74 74 6f | 6e 20 28 73 6f 75 72 63 |it butto|n (sourc|
|00001150| 65 29 20 61 6e 64 20 61 | 20 72 65 63 6f 72 64 73 |e) and a| records|
|00001160| 65 74 20 28 74 61 72 67 | 65 74 29 2e 20 20 43 6c |et (targ|et). Cl|
|00001170| 69 63 6b 69 6e 67 20 74 | 68 65 20 62 75 74 74 6f |icking t|he butto|
|00001180| 6e 20 6d 6f 76 65 73 20 | 74 6f 20 74 68 65 20 70 |n moves |to the p|
|00001190| 72 65 76 69 6f 75 73 20 | 72 65 63 6f 72 64 20 6f |revious |record o|
|000011a0| 66 20 74 68 65 20 72 65 | 63 6f 72 64 73 65 74 20 |f the re|cordset |
|000011b0| 73 6f 75 72 63 65 2e 0d | 0a 0d 0a 53 65 65 20 44 |source..|...See D|
|000011c0| 61 74 61 62 61 73 65 4e | 61 76 69 67 61 74 69 6f |atabaseN|avigatio|
|000011d0| 6e 2e 64 6f 63 20 66 6f | 72 20 67 65 6e 65 72 61 |n.doc fo|r genera|
|000011e0| 6c 20 69 6e 66 6f 72 6d | 61 74 69 6f 6e 20 6f 6e |l inform|ation on|
|000011f0| 20 44 61 74 61 62 61 73 | 65 20 6e 61 76 69 67 61 | Databas|e naviga|
|00001200| 74 69 6f 6e 20 63 6f 6e | 74 72 61 63 74 73 2e 05 |tion con|tracts..|
|00001210| 80 12 00 00 00 3a 47 6f | 20 74 6f 20 74 68 65 20 |.....:Go| to the |
|00001220| 6e 65 78 74 20 72 65 63 | 6f 72 64 20 69 6e 20 5b |next rec|ord in [|
|00001230| 74 61 72 67 65 74 5d 20 | 77 68 65 6e 20 5b 73 6f |target] |when [so|
|00001240| 75 72 63 65 5d 20 69 73 | 20 63 6c 69 63 6b 65 64 |urce] is| clicked|
|00001250| 00 00 00 00 00 02 00 07 | 80 01 00 00 00 06 53 6f |........|......So|
|00001260| 75 72 63 65 01 00 09 80 | 03 00 00 00 00 00 00 00 |urce....|........|
|00001270| 07 6f 6e 43 6c 69 63 6b | 01 00 0b 80 04 00 00 00 |.onClick|........|
|00001280| 07 6f 6e 43 6c 69 63 6b | 01 00 00 00 00 00 00 00 |.onClick|........|
|00001290| 00 07 80 01 00 00 00 06 | 54 61 72 67 65 74 02 00 |........|Target..|
|000012a0| 09 80 03 00 00 00 01 00 | 00 00 0a 4d 6f 76 65 4e |........|...MoveN|
|000012b0| 65 78 74 28 29 09 80 03 | 00 00 00 00 00 00 00 0c |ext()...|........|
|000012c0| 42 65 66 6f 72 65 4f 70 | 65 6e 28 29 01 00 0b 80 |BeforeOp|en()....|
|000012d0| 04 00 00 00 0c 42 65 66 | 6f 72 65 4f 70 65 6e 28 |.....Bef|oreOpen(|
|000012e0| 29 02 00 00 00 00 00 00 | 00 4f 69 66 20 28 52 65 |).......|.Oif (Re|
|000012f0| 71 75 65 73 74 2e 46 6f | 72 6d 2e 4b 65 79 28 22 |quest.Fo|rm.Key("|
|00001300| 5b 53 6f 75 72 63 65 5d | 22 29 20 21 3d 20 22 22 |[Source]|") != ""|
|00001310| 29 20 0d 0a 7b 0d 0a 20 | 20 20 20 5b 54 61 72 67 |) ..{.. | [Targ|
|00001320| 65 74 5d 2e 53 65 74 41 | 63 74 69 6f 6e 28 22 4e |et].SetA|ction("N|
|00001330| 65 78 74 22 29 3b 0d 0a | 7d 01 00 00 00 52 69 66 |ext");..|}....Rif|
|00001340| 20 52 65 71 75 65 73 74 | 2e 46 6f 72 6d 2e 4b 65 | Request|.Form.Ke|
|00001350| 79 28 22 5b 53 6f 75 72 | 63 65 5d 22 29 20 3c 3e |y("[Sour|ce]") <>|
|00001360| 20 22 22 20 74 68 65 6e | 0d 0a 20 20 20 20 5b 54 | "" then|.. [T|
|00001370| 61 72 67 65 74 5d 2e 53 | 65 74 41 63 74 69 6f 6e |arget].S|etAction|
|00001380| 28 22 4e 65 78 74 22 29 | 0d 0a 65 6e 64 20 69 66 |("Next")|..end if|
|00001390| 00 00 13 44 61 74 61 62 | 61 73 65 20 6e 61 76 69 |...Datab|ase navi|
|000013a0| 67 61 74 69 6f 6e 00 00 | 00 00 00 00 04 00 00 00 |gation..|........|
|000013b0| 01 00 00 00 04 00 0b 80 | 04 00 00 00 08 6f 6e 55 |........|.....onU|
|000013c0| 6e 4c 6f 61 64 01 00 00 | 00 00 00 00 00 00 0b 80 |nLoad...|........|
|000013d0| 04 00 00 00 06 53 65 72 | 76 65 72 02 00 00 00 00 |.....Ser|ver.....|
|000013e0| 00 00 00 00 01 00 00 00 | 00 0b 80 04 00 00 00 00 |........|........|
|000013f0| 01 00 00 00 00 00 00 00 | 00 0b 80 04 00 00 00 06 |........|........|
|00001400| 6f 6e 42 6c 75 72 01 00 | 00 00 00 00 00 00 00 1b |onBlur..|........|
|00001410| ca d3 2a 83 16 d2 11 90 | 80 00 60 08 8f 47 c4 01 |..*.....|..`..G..|
|00001420| 00 00 00 24 33 37 37 41 | 43 34 33 30 2d 36 32 31 |...$377A|C430-621|
|00001430| 31 2d 31 31 44 32 2d 38 | 31 31 37 2d 30 30 36 30 |1-11D2-8|117-0060|
|00001440| 30 38 43 38 36 43 32 35 | 03 33 2e 30 ff af 01 56 |08C86C25|.3.0...V|
|00001450| 31 30 5f 33 30 0d 0a 0d | 0a 4e 6f 74 65 3a 20 74 |10_30...|.Note: t|
|00001460| 68 69 73 20 63 6f 6e 74 | 72 61 63 74 20 69 73 20 |his cont|ract is |
|00001470| 75 73 65 64 20 62 79 20 | 74 68 65 20 44 61 74 61 |used by |the Data|
|00001480| 46 6f 72 6d 20 57 69 7a | 61 72 64 2c 20 6d 6f 64 |Form Wiz|ard, mod|
|00001490| 69 66 69 63 61 74 69 6f | 6e 73 20 61 72 65 20 6e |ificatio|ns are n|
|000014a0| 6f 74 20 72 65 63 6f 6d | 6d 65 6e 64 65 64 2e 20 |ot recom|mended. |
|000014b0| 20 49 66 20 79 6f 75 20 | 77 6f 75 6c 64 20 6c 69 | If you |would li|
|000014c0| 6b 65 20 74 6f 20 6d 6f | 64 69 66 79 20 69 74 2c |ke to mo|dify it,|
|000014d0| 20 63 72 65 61 74 65 20 | 61 6e 64 20 6d 6f 64 69 | create |and modi|
|000014e0| 66 79 20 61 20 63 6f 70 | 79 20 74 6f 20 72 65 74 |fy a cop|y to ret|
|000014f0| 61 69 6e 20 74 68 65 20 | 6f 72 69 67 69 6e 61 6c |ain the |original|
|00001500| 2e 0d 0a 0d 0a 54 68 69 | 73 20 63 6f 6e 74 72 61 |.....Thi|s contra|
|00001510| 63 74 20 69 73 20 61 6e | 20 69 6e 74 65 72 61 63 |ct is an| interac|
|00001520| 74 69 6f 6e 20 62 65 74 | 77 65 65 6e 20 61 20 73 |tion bet|ween a s|
|00001530| 75 62 6d 69 74 20 62 75 | 74 74 6f 6e 20 28 73 6f |ubmit bu|tton (so|
|00001540| 75 72 63 65 29 20 61 6e | 64 20 61 20 72 65 63 6f |urce) an|d a reco|
|00001550| 72 64 73 65 74 20 28 74 | 61 72 67 65 74 29 2e 20 |rdset (t|arget). |
|00001560| 20 43 6c 69 63 6b 69 6e | 67 20 74 68 65 20 62 75 | Clickin|g the bu|
|00001570| 74 74 6f 6e 20 6d 6f 76 | 65 73 20 74 6f 20 74 68 |tton mov|es to th|
|00001580| 65 20 6e 65 78 74 20 72 | 65 63 6f 72 64 20 6f 66 |e next r|ecord of|
|00001590| 20 74 68 65 20 72 65 63 | 6f 72 64 73 65 74 20 73 | the rec|ordset s|
|000015a0| 6f 75 72 63 65 2e 0d 0a | 0d 0a 53 65 65 20 44 61 |ource...|..See Da|
|000015b0| 74 61 62 61 73 65 4e 61 | 76 69 67 61 74 69 6f 6e |tabaseNa|vigation|
|000015c0| 2e 64 6f 63 20 66 6f 72 | 20 67 65 6e 65 72 61 6c |.doc for| general|
|000015d0| 20 69 6e 66 6f 72 6d 61 | 74 69 6f 6e 20 6f 6e 20 | informa|tion on |
|000015e0| 44 61 74 61 62 61 73 65 | 20 6e 61 76 69 67 61 74 |Database| navigat|
|000015f0| 69 6f 6e 20 63 6f 6e 74 | 72 61 63 74 73 2e 05 80 |ion cont|racts...|
|00001600| 12 00 00 00 46 47 6f 20 | 74 6f 20 70 61 67 65 6e |....FGo |to pagen|
|00001610| 61 6d 65 20 77 68 65 6e | 20 5b 73 6f 75 72 63 65 |ame when| [source|
|00001620| 5d 20 69 73 20 63 6c 69 | 63 6b 65 64 2c 20 6d 61 |] is cli|cked, ma|
|00001630| 69 6e 74 61 69 6e 69 6e | 67 20 73 74 61 74 65 20 |intainin|g state |
|00001640| 6f 66 20 5b 74 61 72 67 | 65 74 5d 00 00 00 00 00 |of [targ|et].....|
|00001650| 02 00 07 80 01 00 00 00 | 06 53 6f 75 72 63 65 01 |........|.Source.|
|00001660| 00 09 80 03 00 00 00 00 | 00 00 00 07 6f 6e 43 6c |........|....onCl|
|00001670| 69 63 6b 00 00 07 80 01 | 00 00 00 06 54 61 72 67 |ick.....|....Targ|
|00001680| 65 74 02 00 09 80 03 00 | 00 00 00 00 00 00 08 53 |et......|.......S|
|00001690| 65 72 76 65 72 28 29 09 | 80 03 00 00 00 01 00 00 |erver().|........|
|000016a0| 00 0b 4d 6f 76 65 46 69 | 72 73 74 28 29 01 00 0b |..MoveFi|rst()...|
|000016b0| 80 04 00 00 00 08 53 65 | 72 76 65 72 28 29 02 00 |......Se|rver()..|
|000016c0| 00 00 00 00 00 00 9f 69 | 66 20 28 52 65 71 75 65 |.......i|f (Reque|
|000016d0| 73 74 2e 46 6f 72 6d 2e | 4b 65 79 28 22 5b 53 6f |st.Form.|Key("[So|
|000016e0| 75 72 63 65 5d 22 29 20 | 21 3d 20 22 22 29 20 0d |urce]") |!= "") .|
|000016f0| 0a 7b 0d 0a 20 20 20 20 | 52 65 73 70 6f 6e 73 65 |.{.. |Response|
|00001700| 2e 52 65 64 69 72 65 63 | 74 28 65 73 63 61 70 65 |.Redirec|t(escape|
|00001710| 28 5b 70 61 67 65 6e 61 | 6d 65 5d 29 20 2b 20 22 |([pagena|me]) + "|
|00001720| 3f 22 20 2b 20 22 5b 74 | 61 72 67 65 74 5d 5f 50 |?" + "[t|arget]_P|
|00001730| 6f 73 69 74 69 6f 6e 3d | 22 20 2b 20 53 65 72 76 |osition=|" + Serv|
|00001740| 65 72 2e 55 52 4c 45 6e | 63 6f 64 65 28 5b 74 61 |er.URLEn|code([ta|
|00001750| 72 67 65 74 5d 2e 47 65 | 74 53 74 61 74 65 28 29 |rget].Ge|tState()|
|00001760| 29 29 3b 0d 0a 7d 01 00 | 00 00 ad 69 66 20 28 52 |));..}..|...if (R|
|00001770| 65 71 75 65 73 74 2e 46 | 6f 72 6d 2e 4b 65 79 28 |equest.F|orm.Key(|
|00001780| 22 5b 53 6f 75 72 63 65 | 5d 22 29 20 3c 3e 20 22 |"[Source|]") <> "|
|00001790| 22 29 20 74 68 65 6e 0d | 0a 20 20 20 20 52 65 73 |") then.|. Res|
|000017a0| 70 6f 6e 73 65 2e 52 65 | 64 69 72 65 63 74 28 55 |ponse.Re|direct(U|
|000017b0| 52 4c 45 73 63 61 70 65 | 53 70 61 63 65 73 28 5b |RLEscape|Spaces([|
|000017c0| 70 61 67 65 6e 61 6d 65 | 5d 29 20 26 20 22 3f 22 |pagename|]) & "?"|
|000017d0| 20 26 20 22 5b 74 61 72 | 67 65 74 5d 5f 50 6f 73 | & "[tar|get]_Pos|
|000017e0| 69 74 69 6f 6e 3d 22 20 | 2b 20 53 65 72 76 65 72 |ition=" |+ Server|
|000017f0| 2e 55 52 4c 45 6e 63 6f | 64 65 28 5b 74 61 72 67 |.URLEnco|de([targ|
|00001800| 65 74 5d 2e 47 65 74 53 | 74 61 74 65 28 29 29 29 |et].GetS|tate()))|
|00001810| 0d 0a 65 6e 64 20 69 66 | 01 00 ff ff 00 00 0d 00 |..end if|........|
|00001820| 78 78 53 63 72 69 70 74 | 50 61 72 61 6d 05 00 00 |xxScript|Param...|
|00001830| 00 08 70 61 67 65 6e 61 | 6d 65 06 00 00 00 03 00 |..pagena|me......|
|00001840| 01 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 13 |........|........|
|00001850| 44 61 74 61 62 61 73 65 | 20 6e 61 76 69 67 61 74 |Database| navigat|
|00001860| 69 6f 6e 01 00 e0 5a 9c | 93 23 83 d2 11 80 52 00 |ion...Z.|.#....R.|
|00001870| 10 4b d3 38 d1 00 00 00 | 00 04 00 00 00 01 00 00 |.K.8....|........|
|00001880| 00 03 00 0b 80 04 00 00 | 00 06 49 6e 6c 69 6e 65 |........|..Inline|
|00001890| 00 00 00 00 0b 80 04 00 | 00 00 06 53 65 72 76 65 |........|...Serve|
|000018a0| 72 02 00 00 00 00 00 00 | 00 00 01 00 00 00 00 0b |r.......|........|
|000018b0| 80 04 00 00 00 06 6f 6e | 42 6c 75 72 01 00 00 00 |......on|Blur....|
|000018c0| 00 00 00 00 00 65 ee 70 | 0b 76 16 d2 11 90 80 00 |.....e.p|.v......|
|000018d0| 60 08 8f 47 c4 01 00 00 | 00 24 33 37 37 41 43 34 |`..G....|.$377AC4|
|000018e0| 33 30 2d 36 32 31 31 2d | 31 31 44 32 2d 38 31 31 |30-6211-|11D2-811|
|000018f0| 37 2d 30 30 36 30 30 38 | 43 38 36 43 32 35 03 33 |7-006008|C86C25.3|
|00001900| 2e 30 ff 83 02 56 31 30 | 5f 33 30 0d 0a 0d 0a 4e |.0...V10|_30....N|
|00001910| 6f 74 65 3a 20 74 68 69 | 73 20 63 6f 6e 74 72 61 |ote: thi|s contra|
|00001920| 63 74 20 69 73 20 75 73 | 65 64 20 62 79 20 74 68 |ct is us|ed by th|
|00001930| 65 20 44 61 74 61 46 6f | 72 6d 20 57 69 7a 61 72 |e DataFo|rm Wizar|
|00001940| 64 2c 20 6d 6f 64 69 66 | 69 63 61 74 69 6f 6e 73 |d, modif|ications|
|00001950| 20 61 72 65 20 6e 6f 74 | 20 72 65 63 6f 6d 6d 65 | are not| recomme|
|00001960| 6e 64 65 64 2e 20 20 49 | 66 20 79 6f 75 20 77 6f |nded. I|f you wo|
|00001970| 75 6c 64 20 6c 69 6b 65 | 20 74 6f 20 6d 6f 64 69 |uld like| to modi|
|00001980| 66 79 20 69 74 2c 20 63 | 72 65 61 74 65 20 61 6e |fy it, c|reate an|
|00001990| 64 20 6d 6f 64 69 66 79 | 20 61 20 63 6f 70 79 20 |d modify| a copy |
|000019a0| 74 6f 20 72 65 74 61 69 | 6e 20 74 68 65 20 6f 72 |to retai|n the or|
|000019b0| 69 67 69 6e 61 6c 2e 0d | 0a 0d 0a 54 68 69 73 20 |iginal..|...This |
|000019c0| 63 6f 6e 74 72 61 63 74 | 20 69 73 20 61 6e 20 69 |contract| is an i|
|000019d0| 6e 74 65 72 61 63 74 69 | 6f 6e 20 62 65 74 77 65 |nteracti|on betwe|
|000019e0| 65 6e 20 61 20 73 75 62 | 6d 69 74 20 62 75 74 74 |en a sub|mit butt|
|000019f0| 6f 6e 20 28 73 6f 75 72 | 63 65 29 20 61 6e 64 20 |on (sour|ce) and |
|00001a00| 61 20 72 65 63 6f 72 64 | 73 65 74 20 28 74 61 72 |a record|set (tar|
|00001a10| 67 65 74 29 2e 20 20 43 | 6c 69 63 6b 69 6e 67 20 |get). C|licking |
|00001a20| 74 68 65 20 62 75 74 74 | 6f 6e 20 65 78 65 63 75 |the butt|on execu|
|00001a30| 74 65 73 20 74 68 65 20 | 6c 69 6e 6b 20 73 70 65 |tes the |link spe|
|00001a40| 63 69 66 69 65 64 20 69 | 6e 20 74 68 65 20 50 61 |cified i|n the Pa|
|00001a50| 67 65 4e 61 6d 65 20 70 | 61 72 61 6d 65 74 65 72 |geName p|arameter|
|00001a60| 2c 20 62 75 74 20 72 65 | 74 61 69 6e 73 20 74 68 |, but re|tains th|
|00001a70| 65 20 6f 72 69 67 69 6e | 61 6c 20 73 74 61 74 65 |e origin|al state|
|00001a80| 20 6f 66 20 74 68 65 20 | 72 65 63 6f 72 64 73 65 | of the |recordse|
|00001a90| 74 20 69 6e 20 74 68 65 | 20 6f 72 69 67 69 6e 61 |t in the| origina|
|00001aa0| 74 69 6e 67 20 70 61 67 | 65 2e 20 20 54 68 75 73 |ting pag|e. Thus|
|00001ab0| 2c 20 61 66 74 65 72 20 | 65 78 65 63 75 74 69 6e |, after |executin|
|00001ac0| 67 20 74 68 65 20 6c 69 | 6e 6b 2c 20 74 68 65 20 |g the li|nk, the |
|00001ad0| 6f 72 69 67 69 6e 61 6c | 20 70 61 67 65 20 63 61 |original| page ca|
|00001ae0| 6e 20 62 65 20 72 65 74 | 72 69 65 76 65 64 20 69 |n be ret|rieved i|
|00001af0| 6e 20 69 74 73 20 6f 72 | 69 67 69 6e 61 6c 20 73 |n its or|iginal s|
|00001b00| 74 61 74 65 20 77 68 65 | 6e 20 74 68 65 20 62 72 |tate whe|n the br|
|00001b10| 6f 77 73 65 72 27 73 20 | 27 42 61 63 6b 27 20 62 |owser's |'Back' b|
|00001b20| 75 74 74 6f 6e 20 69 73 | 20 70 75 73 68 65 64 2e |utton is| pushed.|
|00001b30| 0d 0a 0d 0a 53 65 65 20 | 44 61 74 61 62 61 73 65 |....See |Database|
|00001b40| 4e 61 76 69 67 61 74 69 | 6f 6e 2e 64 6f 63 20 66 |Navigati|on.doc f|
|00001b50| 6f 72 20 67 65 6e 65 72 | 61 6c 20 69 6e 66 6f 72 |or gener|al infor|
|00001b60| 6d 61 74 69 6f 6e 20 6f | 6e 20 44 61 74 61 62 61 |mation o|n Databa|
|00001b70| 73 65 20 6e 61 76 69 67 | 61 74 69 6f 6e 20 63 6f |se navig|ation co|
|00001b80| 6e 74 72 61 63 74 73 2e | 05 80 12 00 00 00 46 53 |ntracts.|......FS|
|00001b90| 65 74 2f 6d 6f 76 65 20 | 41 75 74 6f 54 61 62 6c |et/move |AutoTabl|
|00001ba0| 65 20 5b 74 61 72 67 65 | 74 5d 20 64 69 72 65 63 |e [targe|t] direc|
|00001bb0| 74 69 6f 6e 20 66 6f 72 | 77 61 72 64 20 77 68 65 |tion for|ward whe|
|00001bc0| 6e 20 5b 73 6f 75 72 63 | 65 5d 20 69 73 20 63 6c |n [sourc|e] is cl|
|00001bd0| 69 63 6b 65 64 00 00 00 | 00 00 02 00 07 80 01 00 |icked...|........|
|00001be0| 00 00 06 53 6f 75 72 63 | 65 01 00 09 80 03 00 00 |...Sourc|e.......|
|00001bf0| 00 00 00 00 00 07 6f 6e | 43 6c 69 63 6b 01 00 0b |......on|Click...|
|00001c00| 80 04 00 00 00 07 6f 6e | 43 6c 69 63 6b 01 00 00 |......on|Click...|
|00001c10| 00 00 00 00 00 00 07 80 | 01 00 00 00 06 54 61 72 |........|.....Tar|
|00001c20| 67 65 74 01 00 09 80 03 | 00 00 00 01 00 00 00 0a |get.....|........|
|00001c30| 6e 65 78 74 50 61 67 65 | 28 29 00 00 00 00 13 44 |nextPage|().....D|
|00001c40| 61 74 61 62 61 73 65 20 | 6e 61 76 69 67 61 74 69 |atabase |navigati|
|00001c50| 6f 6e 00 00 00 00 00 00 | 04 00 00 00 01 00 00 00 |on......|........|
|00001c60| 03 00 0b 80 04 00 00 00 | 06 53 65 72 76 65 72 02 |........|.Server.|
|00001c70| 00 00 00 00 00 00 00 58 | 69 66 20 28 53 74 72 69 |.......X|if (Stri|
|00001c80| 6e 67 28 52 65 71 75 65 | 73 74 28 22 5b 53 6f 75 |ng(Reque|st("[Sou|
|00001c90| 72 63 65 5d 22 29 29 20 | 21 3d 20 22 75 6e 64 65 |rce]")) |!= "unde|
|00001ca0| 66 69 6e 65 64 22 29 20 | 0d 0a 7b 0d 0a 20 20 20 |fined") |..{.. |
|00001cb0| 20 5b 54 61 72 67 65 74 | 5d 5f 41 63 74 69 6f 6e | [Target|]_Action|
|00001cc0| 20 3d 20 22 46 6f 72 77 | 61 72 64 22 3b 0d 0a 7d | = "Forw|ard";..}|
|00001cd0| 01 00 00 00 51 69 66 20 | 4e 6f 74 20 49 73 45 6d |....Qif |Not IsEm|
|00001ce0| 70 74 79 28 52 65 71 75 | 65 73 74 28 22 5b 53 6f |pty(Requ|est("[So|
|00001cf0| 75 72 63 65 5d 22 29 29 | 20 74 68 65 6e 0d 0a 20 |urce]"))| then.. |
|00001d00| 20 20 20 5b 54 61 72 67 | 65 74 5d 5f 41 63 74 69 | [Targ|et]_Acti|
|00001d10| 6f 6e 20 3d 20 22 46 6f | 72 77 61 72 64 22 0d 0a |on = "Fo|rward"..|
|00001d20| 65 6e 64 20 69 66 0b 80 | 04 00 00 00 00 01 00 00 |end if..|........|
|00001d30| 00 00 00 00 00 00 0b 80 | 04 00 00 00 06 6f 6e 42 |........|.....onB|
|00001d40| 6c 75 72 01 00 00 00 00 | 00 00 00 00 22 db b7 4a |lur.....|...."..J|
|00001d50| 97 16 d2 11 90 80 00 60 | 08 8f 47 c4 01 00 00 00 |.......`|..G.....|
|00001d60| 24 33 37 37 41 43 34 33 | 30 2d 36 32 31 31 2d 31 |$377AC43|0-6211-1|
|00001d70| 31 44 32 2d 38 31 31 37 | 2d 30 30 36 30 30 38 43 |1D2-8117|-006008C|
|00001d80| 38 36 43 32 35 03 33 2e | 30 ff da 01 56 31 30 5f |86C25.3.|0...V10_|
|00001d90| 33 30 0d 0a 0d 0a 4e 6f | 74 65 3a 20 74 68 69 73 |30....No|te: this|
|00001da0| 20 63 6f 6e 74 72 61 63 | 74 20 69 73 20 75 73 65 | contrac|t is use|
|00001db0| 64 20 62 79 20 74 68 65 | 20 44 61 74 61 46 6f 72 |d by the| DataFor|
|00001dc0| 6d 20 57 69 7a 61 72 64 | 2c 20 6d 6f 64 69 66 69 |m Wizard|, modifi|
|00001dd0| 63 61 74 69 6f 6e 73 20 | 61 72 65 20 6e 6f 74 20 |cations |are not |
|00001de0| 72 65 63 6f 6d 6d 65 6e | 64 65 64 2e 20 20 49 66 |recommen|ded. If|
|00001df0| 20 79 6f 75 20 77 6f 75 | 6c 64 20 6c 69 6b 65 20 | you wou|ld like |
|00001e00| 74 6f 20 6d 6f 64 69 66 | 79 20 69 74 2c 20 63 72 |to modif|y it, cr|
|00001e10| 65 61 74 65 20 61 6e 64 | 20 6d 6f 64 69 66 79 20 |eate and| modify |
|00001e20| 61 20 63 6f 70 79 20 74 | 6f 20 72 65 74 61 69 6e |a copy t|o retain|
|00001e30| 20 74 68 65 20 6f 72 69 | 67 69 6e 61 6c 2e 0d 0a | the ori|ginal...|
|00001e40| 0d 0a 54 68 69 73 20 63 | 6f 6e 74 72 61 63 74 20 |..This c|ontract |
|00001e50| 69 73 20 61 6e 20 69 6e | 74 65 72 61 63 74 69 6f |is an in|teractio|
|00001e60| 6e 20 62 65 74 77 65 65 | 6e 20 61 20 73 75 62 6d |n betwee|n a subm|
|00001e70| 69 74 20 62 75 74 74 6f | 6e 20 28 73 6f 75 72 63 |it butto|n (sourc|
|00001e80| 65 29 20 61 6e 64 20 61 | 6e 20 41 75 74 6f 74 61 |e) and a|n Autota|
|00001e90| 62 6c 65 20 28 74 61 72 | 67 65 74 29 2e 20 20 43 |ble (tar|get). C|
|00001ea0| 6c 69 63 6b 69 6e 67 20 | 74 68 65 20 62 75 74 74 |licking |the butt|
|00001eb0| 6f 6e 20 75 70 64 61 74 | 65 73 20 74 68 65 20 41 |on updat|es the A|
|00001ec0| 75 74 6f 74 61 62 6c 65 | 20 77 69 74 68 20 74 68 |utotable| with th|
|00001ed0| 65 20 6e 65 78 74 20 62 | 6c 6f 63 6b 20 6f 66 20 |e next b|lock of |
|00001ee0| 72 65 63 6f 72 64 73 20 | 69 6e 20 74 68 65 20 41 |records |in the A|
|00001ef0| 75 74 6f 74 61 62 6c 65 | 27 73 20 72 65 63 6f 72 |utotable|'s recor|
|00001f00| 64 20 73 6f 75 72 63 65 | 2e 0d 0a 0d 0a 53 65 65 |d source|.....See|
|00001f10| 20 44 61 74 61 62 61 73 | 65 4e 61 76 69 67 61 74 | Databas|eNavigat|
|00001f20| 69 6f 6e 2e 64 6f 63 20 | 66 6f 72 20 67 65 6e 65 |ion.doc |for gene|
|00001f30| 72 61 6c 20 69 6e 66 6f | 72 6d 61 74 69 6f 6e 20 |ral info|rmation |
|00001f40| 6f 6e 20 44 61 74 61 62 | 61 73 65 20 6e 61 76 69 |on Datab|ase navi|
|00001f50| 67 61 74 69 6f 6e 20 63 | 6f 6e 74 72 61 63 74 73 |gation c|ontracts|
|00001f60| 2e 20 0d 0a 0d 0a 05 80 | 12 00 00 00 47 53 65 74 |. ......|....GSet|
|00001f70| 2f 6d 6f 76 65 20 41 75 | 74 6f 54 61 62 6c 65 20 |/move Au|toTable |
|00001f80| 5b 74 61 72 67 65 74 5d | 20 64 69 72 65 63 74 69 |[target]| directi|
|00001f90| 6f 6e 20 62 61 63 6b 77 | 61 72 64 20 77 68 65 6e |on backw|ard when|
|00001fa0| 20 5b 73 6f 75 72 63 65 | 5d 20 69 73 20 63 6c 69 | [source|] is cli|
|00001fb0| 63 6b 65 64 00 00 00 00 | 00 02 00 07 80 01 00 00 |cked....|........|
|00001fc0| 00 06 53 6f 75 72 63 65 | 01 00 09 80 03 00 00 00 |..Source|........|
|00001fd0| 00 00 00 00 07 6f 6e 43 | 6c 69 63 6b 01 00 0b 80 |.....onC|lick....|
|00001fe0| 04 00 00 00 07 6f 6e 43 | 6c 69 63 6b 01 00 00 00 |.....onC|lick....|
|00001ff0| 00 00 00 00 00 07 80 01 | 00 00 00 06 54 61 72 67 |........|....Targ|
|00002000| 65 74 01 00 09 80 03 00 | 00 00 01 00 00 00 0e 70 |et......|.......p|
|00002010| 72 65 76 69 6f 75 73 50 | 61 67 65 28 29 00 00 00 |reviousP|age()...|
|00002020| 00 13 44 61 74 61 62 61 | 73 65 20 6e 61 76 69 67 |..Databa|se navig|
|00002030| 61 74 69 6f 6e 00 00 00 | 00 00 00 04 00 00 00 01 |ation...|........|
|00002040| 00 00 00 02 00 0b 80 04 | 00 00 00 06 53 65 72 76 |........|....Serv|
|00002050| 65 72 02 00 00 00 00 00 | 00 00 59 69 66 20 28 53 |er......|..Yif (S|
|00002060| 74 72 69 6e 67 28 52 65 | 71 75 65 73 74 28 22 5b |tring(Re|quest("[|
|00002070| 53 6f 75 72 63 65 5d 22 | 29 29 20 21 3d 20 22 75 |Source]"|)) != "u|
|00002080| 6e 64 65 66 69 6e 65 64 | 22 29 20 0d 0a 7b 0d 0a |ndefined|") ..{..|
|00002090| 20 20 20 20 5b 54 61 72 | 67 65 74 5d 5f 41 63 74 | [Tar|get]_Act|
|000020a0| 69 6f 6e 20 3d 20 22 42 | 61 63 6b 77 61 72 64 22 |ion = "B|ackward"|
|000020b0| 3b 0d 0a 7d 01 00 00 00 | 52 69 66 20 4e 6f 74 20 |;..}....|Rif Not |
|000020c0| 49 73 45 6d 70 74 79 28 | 52 65 71 75 65 73 74 28 |IsEmpty(|Request(|
|000020d0| 22 5b 53 6f 75 72 63 65 | 5d 22 29 29 20 74 68 65 |"[Source|]")) the|
|000020e0| 6e 0d 0a 20 20 20 20 5b | 54 61 72 67 65 74 5d 5f |n.. [|Target]_|
|000020f0| 41 63 74 69 6f 6e 20 3d | 20 22 42 61 63 6b 77 61 |Action =| "Backwa|
|00002100| 72 64 22 0d 0a 65 6e 64 | 20 69 66 0b 80 04 00 00 |rd"..end| if.....|
|00002110| 00 06 6f 6e 42 6c 75 72 | 01 00 00 00 00 00 00 00 |..onBlur|........|
|00002120| 00 23 db b7 4a 97 16 d2 | 11 90 80 00 60 08 8f 47 |.#..J...|....`..G|
|00002130| c4 01 00 00 00 24 33 37 | 37 41 43 34 33 30 2d 36 |.....$37|7AC430-6|
|00002140| 32 31 31 2d 31 31 44 32 | 2d 38 31 31 37 2d 30 30 |211-11D2|-8117-00|
|00002150| 36 30 30 38 43 38 36 43 | 32 35 03 33 2e 30 ff d9 |6008C86C|25.3.0..|
|00002160| 01 56 31 30 5f 33 30 0d | 0a 0d 0a 4e 6f 74 65 3a |.V10_30.|...Note:|
|00002170| 20 74 68 69 73 20 63 6f | 6e 74 72 61 63 74 20 69 | this co|ntract i|
|00002180| 73 20 75 73 65 64 20 62 | 79 20 74 68 65 20 44 61 |s used b|y the Da|
|00002190| 74 61 46 6f 72 6d 20 57 | 69 7a 61 72 64 2c 20 6d |taForm W|izard, m|
|000021a0| 6f 64 69 66 69 63 61 74 | 69 6f 6e 73 20 61 72 65 |odificat|ions are|
|000021b0| 20 6e 6f 74 20 72 65 63 | 6f 6d 6d 65 6e 64 65 64 | not rec|ommended|
|000021c0| 2e 20 20 49 66 20 79 6f | 75 20 77 6f 75 6c 64 20 |. If yo|u would |
|000021d0| 6c 69 6b 65 20 74 6f 20 | 6d 6f 64 69 66 79 20 69 |like to |modify i|
|000021e0| 74 2c 20 63 72 65 61 74 | 65 20 61 6e 64 20 6d 6f |t, creat|e and mo|
|000021f0| 64 69 66 79 20 61 20 63 | 6f 70 79 20 74 6f 20 72 |dify a c|opy to r|
|00002200| 65 74 61 69 6e 20 74 68 | 65 20 6f 72 69 67 69 6e |etain th|e origin|
|00002210| 61 6c 2e 0d 0a 0d 0a 54 | 68 69 73 20 63 6f 6e 74 |al.....T|his cont|
|00002220| 72 61 63 74 20 69 73 20 | 61 6e 20 69 6e 74 65 72 |ract is |an inter|
|00002230| 61 63 74 69 6f 6e 20 62 | 65 74 77 65 65 6e 20 61 |action b|etween a|
|00002240| 20 73 75 62 6d 69 74 20 | 62 75 74 74 6f 6e 20 28 | submit |button (|
|00002250| 73 6f 75 72 63 65 29 20 | 61 6e 64 20 61 6e 20 41 |source) |and an A|
|00002260| 75 74 6f 74 61 62 6c 65 | 20 28 74 61 72 67 65 74 |utotable| (target|
|00002270| 29 2e 20 20 43 6c 69 63 | 6b 69 6e 67 20 74 68 65 |). Clic|king the|
|00002280| 20 62 75 74 74 6f 6e 20 | 75 70 64 61 74 65 73 20 | button |updates |
|00002290| 74 68 65 20 41 75 74 6f | 74 61 62 6c 65 20 77 69 |the Auto|table wi|
|000022a0| 74 68 20 74 68 65 20 70 | 72 65 76 69 6f 75 73 20 |th the p|revious |
|000022b0| 62 6c 6f 63 6b 20 6f 66 | 20 72 65 63 6f 72 64 73 |block of| records|
|000022c0| 20 69 6e 20 74 68 65 20 | 41 75 74 6f 74 61 62 6c | in the |Autotabl|
|000022d0| 65 27 73 20 72 65 63 6f | 72 64 20 73 6f 75 72 63 |e's reco|rd sourc|
|000022e0| 65 2e 0d 0a 0d 0a 53 65 | 65 20 44 61 74 61 62 61 |e.....Se|e Databa|
|000022f0| 73 65 4e 61 76 69 67 61 | 74 69 6f 6e 2e 64 6f 63 |seNaviga|tion.doc|
|00002300| 20 66 6f 72 20 67 65 6e | 65 72 61 6c 20 69 6e 66 | for gen|eral inf|
|00002310| 6f 72 6d 61 74 69 6f 6e | 20 6f 6e 20 44 61 74 61 |ormation| on Data|
|00002320| 62 61 73 65 20 6e 61 76 | 69 67 61 74 69 6f 6e 20 |base nav|igation |
|00002330| 63 6f 6e 74 72 61 63 74 | 73 2e 05 80 12 00 00 00 |contract|s.......|
|00002340| 50 44 69 73 70 6c 61 79 | 20 70 72 65 76 69 6f 75 |PDisplay| previou|
|00002350| 73 20 73 65 74 20 6f 66 | 20 72 65 63 6f 72 64 73 |s set of| records|
|00002360| 20 66 72 6f 6d 20 5b 74 | 61 72 67 65 74 5d 20 69 | from [t|arget] i|
|00002370| 6e 20 4c 6f 6f 70 65 72 | 20 77 68 65 6e 20 5b 73 |n Looper| when [s|
|00002380| 6f 75 72 63 65 5d 20 69 | 73 20 63 6c 69 63 6b 65 |ource] i|s clicke|
|00002390| 64 00 00 00 00 00 02 00 | 07 80 01 00 00 00 06 53 |d.......|.......S|
|000023a0| 6f 75 72 63 65 01 00 09 | 80 03 00 00 00 00 00 00 |ource...|........|
|000023b0| 00 07 6f 6e 43 6c 69 63 | 6b 01 00 0b 80 04 00 00 |..onClic|k.......|
|000023c0| 00 07 6f 6e 43 6c 69 63 | 6b 01 00 00 00 00 00 00 |..onClic|k.......|
|000023d0| 00 00 07 80 01 00 00 00 | 06 54 61 72 67 65 74 02 |........|.Target.|
|000023e0| 00 09 80 03 00 00 00 01 | 00 00 00 0e 4d 6f 76 65 |........|....Move|
|000023f0| 28 70 6f 73 69 74 69 6f | 6e 29 09 80 03 00 00 00 |(positio|n)......|
|00002400| 00 00 00 00 08 53 65 72 | 76 65 72 28 29 01 00 0b |.....Ser|ver()...|
|00002410| 80 04 00 00 00 08 53 65 | 72 76 65 72 28 29 02 00 |......Se|rver()..|
|00002420| 00 00 00 00 00 00 ff 54 | 01 69 66 20 28 52 65 71 |.......T|.if (Req|
|00002430| 75 65 73 74 2e 46 6f 72 | 6d 2e 4b 65 79 28 22 5b |uest.For|m.Key("[|
|00002440| 53 6f 75 72 63 65 5d 22 | 29 20 21 3d 20 22 22 29 |Source]"|) != "")|
|00002450| 20 0d 0a 7b 0d 0a 09 4c | 6f 6f 70 65 72 4e 61 6d | ..{...L|ooperNam|
|00002460| 65 20 3d 20 5b 4c 6f 6f | 70 65 72 4e 61 6d 65 5d |e = [Loo|perName]|
|00002470| 3b 0d 0a 0d 0a 09 4d 6f | 76 65 42 79 20 3d 20 32 |;.....Mo|veBy = 2|
|00002480| 20 2a 20 70 61 72 73 65 | 49 6e 74 28 5b 50 61 67 | * parse|Int([Pag|
|00002490| 65 53 69 7a 65 5d 29 3b | 0d 0a 09 69 66 28 52 65 |eSize]);|...if(Re|
|000024a0| 71 75 65 73 74 28 4c 6f | 6f 70 65 72 4e 61 6d 65 |quest(Lo|operName|
|000024b0| 2b 22 5f 53 74 61 74 65 | 22 29 20 21 3d 20 6e 75 |+"_State|") != nu|
|000024c0| 6c 6c 20 26 26 20 52 65 | 71 75 65 73 74 28 4c 6f |ll && Re|quest(Lo|
|000024d0| 6f 70 65 72 4e 61 6d 65 | 2b 22 5f 53 74 61 74 65 |operName|+"_State|
|000024e0| 22 29 20 21 3d 20 22 22 | 29 0d 0a 09 7b 0d 0a 09 |") != ""|)...{...|
|000024f0| 09 4d 6f 76 65 42 79 20 | 3d 20 70 61 72 73 65 49 |.MoveBy |= parseI|
|00002500| 6e 74 28 5b 50 61 67 65 | 53 69 7a 65 5d 29 20 2b |nt([Page|Size]) +|
|00002510| 20 70 61 72 73 65 49 6e | 74 28 52 65 71 75 65 73 | parseIn|t(Reques|
|00002520| 74 28 4c 6f 6f 70 65 72 | 4e 61 6d 65 2b 22 5f 53 |t(Looper|Name+"_S|
|00002530| 74 61 74 65 22 29 29 3b | 0d 0a 20 20 69 66 20 28 |tate"));|.. if (|
|00002540| 4d 6f 76 65 42 79 20 3e | 20 30 29 20 0d 0a 20 20 |MoveBy >| 0) .. |
|00002550| 7b 20 20 0d 0a 20 20 20 | 5b 54 61 72 67 65 74 5d |{ .. |[Target]|
|00002560| 2e 4d 6f 76 65 28 2d 4d | 6f 76 65 42 79 29 3b 0d |.Move(-M|oveBy);.|
|00002570| 0a 20 20 7d 0d 0a 09 7d | 0d 0a 0d 0a 7d 01 00 00 |. }...}|....}...|
|00002580| 00 ff 35 01 69 66 20 28 | 52 65 71 75 65 73 74 2e |..5.if (|Request.|
|00002590| 46 6f 72 6d 2e 4b 65 79 | 28 22 5b 53 6f 75 72 63 |Form.Key|("[Sourc|
|000025a0| 65 5d 22 29 20 3c 3e 20 | 22 22 29 20 74 68 65 6e |e]") <> |"") then|
|000025b0| 0d 0a 09 4c 6f 6f 70 65 | 72 4e 61 6d 65 20 3d 20 |...Loope|rName = |
|000025c0| 5b 4c 6f 6f 70 65 72 4e | 61 6d 65 5d 0d 0a 09 4d |[LooperN|ame]...M|
|000025d0| 6f 76 65 42 79 20 3d 20 | 32 20 2a 20 43 49 6e 74 |oveBy = |2 * CInt|
|000025e0| 28 5b 50 61 67 65 53 69 | 7a 65 5d 29 0d 0a 09 69 |([PageSi|ze])...i|
|000025f0| 66 28 52 65 71 75 65 73 | 74 28 4c 6f 6f 70 65 72 |f(Reques|t(Looper|
|00002600| 4e 61 6d 65 20 26 20 22 | 5f 53 74 61 74 65 22 29 |Name & "|_State")|
|00002610| 20 3c 3e 20 22 22 29 20 | 74 68 65 6e 0d 0a 09 09 | <> "") |then....|
|00002620| 4d 6f 76 65 42 79 20 3d | 20 70 61 72 73 65 49 6e |MoveBy =| parseIn|
|00002630| 74 28 5b 50 61 67 65 53 | 69 7a 65 5d 29 20 2b 20 |t([PageS|ize]) + |
|00002640| 70 61 72 73 65 49 6e 74 | 28 52 65 71 75 65 73 74 |parseInt|(Request|
|00002650| 28 4c 6f 6f 70 65 72 4e | 61 6d 65 20 26 20 22 5f |(LooperN|ame & "_|
|00002660| 53 74 61 74 65 22 29 29 | 0d 0a 20 20 69 66 20 28 |State"))|.. if (|
|00002670| 4d 6f 76 65 42 79 29 20 | 74 68 65 6e 0d 0a 20 20 |MoveBy) |then.. |
|00002680| 20 20 20 20 5b 54 61 72 | 67 65 74 5d 2e 4d 6f 76 | [Tar|get].Mov|
|00002690| 65 28 2d 4d 6f 76 65 42 | 79 29 20 20 20 20 0d 0a |e(-MoveB|y) ..|
|000026a0| 20 20 65 6e 64 20 69 66 | 0d 0a 09 65 6e 64 20 69 | end if|...end i|
|000026b0| 66 0d 0a 65 6e 64 20 69 | 66 02 00 3e 80 05 00 00 |f..end i|f..>....|
|000026c0| 00 08 50 61 67 65 53 69 | 7a 65 02 00 00 00 03 00 |..PageSi|ze......|
|000026d0| 01 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 3e |........|.......>|
|000026e0| 80 05 00 00 00 0a 4c 6f | 6f 70 65 72 4e 61 6d 65 |......Lo|operName|
|000026f0| 00 00 00 00 08 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002700| 00 00 00 00 00 13 44 61 | 74 61 62 61 73 65 20 6e |......Da|tabase n|
|00002710| 61 76 69 67 61 74 69 6f | 6e 00 00 00 00 00 00 04 |avigatio|n.......|
|00002720| 00 00 00 01 00 00 00 04 | 00 0b 80 04 00 00 00 06 |........|........|
|00002730| 49 6e 6c 69 6e 65 00 00 | 00 00 0b 80 04 00 00 00 |Inline..|........|
|00002740| 06 53 65 72 76 65 72 02 | 00 00 00 00 00 00 00 00 |.Server.|........|
|00002750| 01 00 00 00 00 0b 80 04 | 00 00 00 00 01 00 00 00 |........|........|
|00002760| 00 00 00 00 00 0b 80 04 | 00 00 00 06 6f 6e 42 6c |........|....onBl|
|00002770| 75 72 01 00 00 00 00 00 | 00 00 00 bc 44 f9 fc b5 |ur......|....D...|
|00002780| 49 d2 11 90 c2 00 60 08 | 8f 47 c4 01 00 00 00 24 |I.....`.|.G.....$|
|00002790| 33 37 37 41 43 34 33 30 | 2d 36 32 31 31 2d 31 31 |377AC430|-6211-11|
|000027a0| 44 32 2d 38 31 31 37 2d | 30 30 36 30 30 38 43 38 |D2-8117-|006008C8|
|000027b0| 36 43 32 35 03 33 2e 30 | ff f9 02 56 31 30 5f 33 |6C25.3.0|...V10_3|
|000027c0| 30 0d 0a 0d 0a 4e 6f 74 | 65 3a 20 74 68 69 73 20 |0....Not|e: this |
|000027d0| 63 6f 6e 74 72 61 63 74 | 20 69 73 20 75 73 65 64 |contract| is used|
|000027e0| 20 62 79 20 74 68 65 20 | 44 61 74 61 46 6f 72 6d | by the |DataForm|
|000027f0| 20 57 69 7a 61 72 64 2c | 20 6d 6f 64 69 66 69 63 | Wizard,| modific|
|00002800| 61 74 69 6f 6e 73 20 61 | 72 65 20 6e 6f 74 20 72 |ations a|re not r|
|00002810| 65 63 6f 6d 6d 65 6e 64 | 65 64 2e 20 20 49 66 20 |ecommend|ed. If |
|00002820| 79 6f 75 20 77 6f 75 6c | 64 20 6c 69 6b 65 20 74 |you woul|d like t|
|00002830| 6f 20 6d 6f 64 69 66 79 | 20 69 74 2c 20 63 72 65 |o modify| it, cre|
|00002840| 61 74 65 20 61 6e 64 20 | 6d 6f 64 69 66 79 20 61 |ate and |modify a|
|00002850| 20 63 6f 70 79 20 74 6f | 20 72 65 74 61 69 6e 20 | copy to| retain |
|00002860| 74 68 65 20 6f 72 69 67 | 69 6e 61 6c 2e 0d 0a 0d |the orig|inal....|
|00002870| 0a 54 68 69 73 20 63 6f | 6e 74 72 61 63 74 20 69 |.This co|ntract i|
|00002880| 73 20 61 6e 20 69 6e 74 | 65 72 61 63 74 69 6f 6e |s an int|eraction|
|00002890| 20 62 65 74 77 65 65 6e | 20 61 20 73 75 62 6d 69 | between| a submi|
|000028a0| 74 20 62 75 74 74 6f 6e | 20 28 73 6f 75 72 63 65 |t button| (source|
|000028b0| 29 20 61 6e 64 20 61 20 | 72 65 63 6f 72 64 73 65 |) and a |recordse|
|000028c0| 74 20 28 74 61 72 67 65 | 74 29 2e 20 20 49 74 20 |t (targe|t). It |
|000028d0| 69 73 20 69 6e 74 65 6e | 64 65 64 20 66 6f 72 20 |is inten|ded for |
|000028e0| 75 73 65 20 77 69 74 68 | 20 74 68 65 20 6c 6f 6f |use with| the loo|
|000028f0| 70 65 72 20 53 6d 61 72 | 74 20 65 6c 65 6d 65 6e |per Smar|t elemen|
|00002900| 74 20 61 6e 64 20 64 6f | 65 73 20 6e 6f 74 20 63 |t and do|es not c|
|00002910| 75 72 72 65 6e 74 6c 79 | 20 77 6f 72 6b 20 77 69 |urrently| work wi|
|00002920| 74 68 20 74 68 65 20 41 | 75 74 6f 54 61 62 6c 65 |th the A|utoTable|
|00002930| 2e 20 20 43 6c 69 63 6b | 69 6e 67 20 74 68 65 20 |. Click|ing the |
|00002940| 62 75 74 74 6f 6e 20 6d | 6f 76 65 73 20 74 6f 20 |button m|oves to |
|00002950| 74 68 65 20 70 72 65 76 | 69 6f 75 73 20 73 65 74 |the prev|ious set|
|00002960| 20 6f 66 20 72 65 63 6f | 72 64 73 20 69 6e 20 74 | of reco|rds in t|
|00002970| 68 65 20 72 65 63 6f 72 | 64 73 65 74 20 73 6f 75 |he recor|dset sou|
|00002980| 72 63 65 20 61 6e 64 20 | 75 70 64 61 74 65 73 20 |rce and |updates |
|00002990| 74 68 65 20 64 69 73 70 | 6c 61 79 65 64 20 72 65 |the disp|layed re|
|000029a0| 63 6f 72 64 73 20 69 6e | 20 74 68 65 20 6c 6f 6f |cords in| the loo|
|000029b0| 70 65 72 20 62 6f 75 6e | 64 20 74 6f 20 74 68 65 |per boun|d to the|
|000029c0| 20 72 65 63 6f 72 64 20 | 73 6f 75 72 63 65 2e 20 | record |source. |
|000029d0| 20 49 6e 63 72 65 6d 65 | 6e 74 69 6e 67 20 74 68 | Increme|nting th|
|000029e0| 65 20 73 65 74 20 6f 66 | 20 72 65 63 6f 72 64 73 |e set of| records|
|000029f0| 20 69 73 20 63 6f 6e 74 | 72 6f 6c 6c 65 64 20 77 | is cont|rolled w|
|00002a00| 69 74 68 20 74 68 65 20 | 70 61 67 65 20 73 69 7a |ith the |page siz|
|00002a10| 65 20 70 61 72 61 6d 65 | 74 65 72 2c 20 77 68 69 |e parame|ter, whi|
|00002a20| 63 68 20 73 70 65 63 69 | 66 69 65 73 20 68 6f 77 |ch speci|fies how|
|00002a30| 20 6d 61 6e 79 20 72 65 | 63 6f 72 64 73 20 61 72 | many re|cords ar|
|00002a40| 65 20 61 73 73 6f 63 69 | 61 74 65 64 20 77 69 74 |e associ|ated wit|
|00002a50| 68 20 74 68 65 20 22 73 | 65 74 2e 22 0d 0a 0d 0a |h the "s|et."....|
|00002a60| 53 65 65 20 44 61 74 61 | 62 61 73 65 4e 61 76 69 |See Data|baseNavi|
|00002a70| 67 61 74 69 6f 6e 2e 64 | 6f 63 20 66 6f 72 20 67 |gation.d|oc for g|
|00002a80| 65 6e 65 72 61 6c 20 69 | 6e 66 6f 72 6d 61 74 69 |eneral i|nformati|
|00002a90| 6f 6e 20 6f 6e 20 44 61 | 74 61 62 61 73 65 20 6e |on on Da|tabase n|
|00002aa0| 61 76 69 67 61 74 69 6f | 6e 20 63 6f 6e 74 72 61 |avigatio|n contra|
|00002ab0| 63 74 73 2e 05 80 12 00 | 00 00 4c 44 69 73 70 6c |cts.....|..LDispl|
|00002ac0| 61 79 20 6c 61 73 74 20 | 73 65 74 20 6f 66 20 72 |ay last |set of r|
|00002ad0| 65 63 6f 72 64 73 20 66 | 72 6f 6d 20 5b 74 61 72 |ecords f|rom [tar|
|00002ae0| 67 65 74 5d 20 69 6e 20 | 4c 6f 6f 70 65 72 20 77 |get] in |Looper w|
|00002af0| 68 65 6e 20 5b 73 6f 75 | 72 63 65 5d 20 69 73 20 |hen [sou|rce] is |
|00002b00| 63 6c 69 63 6b 65 64 00 | 00 00 00 00 02 00 07 80 |clicked.|........|
|00002b10| 01 00 00 00 06 53 6f 75 | 72 63 65 01 00 09 80 03 |.....Sou|rce.....|
|00002b20| 00 00 00 00 00 00 00 07 | 6f 6e 43 6c 69 63 6b 01 |........|onClick.|
|00002b30| 00 0b 80 04 00 00 00 07 | 6f 6e 43 6c 69 63 6b 01 |........|onClick.|
|00002b40| 00 00 00 00 00 00 00 00 | 07 80 01 00 00 00 06 54 |........|.......T|
|00002b50| 61 72 67 65 74 02 00 09 | 80 03 00 00 00 01 00 00 |arget...|........|
|00002b60| 00 0e 4d 6f 76 65 28 70 | 6f 73 69 74 69 6f 6e 29 |..Move(p|osition)|
|00002b70| 09 80 03 00 00 00 00 00 | 00 00 08 53 65 72 76 65 |........|...Serve|
|00002b80| 72 28 29 01 00 0b 80 04 | 00 00 00 08 53 65 72 76 |r().....|....Serv|
|00002b90| 65 72 28 29 02 00 00 00 | 00 00 00 00 76 69 66 20 |er()....|....vif |
|00002ba0| 28 52 65 71 75 65 73 74 | 2e 46 6f 72 6d 2e 4b 65 |(Request|.Form.Ke|
|00002bb0| 79 28 22 5b 53 6f 75 72 | 63 65 5d 22 29 20 21 3d |y("[Sour|ce]") !=|
|00002bc0| 20 22 22 29 0d 0a 7b 0d | 0a 20 20 20 20 5b 54 61 | "")..{.|. [Ta|
|00002bd0| 72 67 65 74 5d 2e 4d 6f | 76 65 4c 61 73 74 28 29 |rget].Mo|veLast()|
|00002be0| 3b 0d 0a 20 20 20 20 5b | 54 61 72 67 65 74 5d 2e |;.. [|Target].|
|00002bf0| 4d 6f 76 65 28 2d 28 70 | 61 72 73 65 49 6e 74 28 |Move(-(p|arseInt(|
|00002c00| 5b 50 61 67 65 53 69 7a | 65 5d 29 2d 31 29 29 3b |[PageSiz|e])-1));|
|00002c10| 0d 0a 7d 01 00 00 00 75 | 69 66 20 52 65 71 75 65 |..}....u|if Reque|
|00002c20| 73 74 2e 46 6f 72 6d 2e | 4b 65 79 28 22 5b 53 6f |st.Form.|Key("[So|
|00002c30| 75 72 63 65 5d 22 29 20 | 3c 3e 20 22 22 20 74 68 |urce]") |<> "" th|
|00002c40| 65 6e 0d 0a 20 20 20 20 | 5b 54 61 72 67 65 74 5d |en.. |[Target]|
|00002c50| 2e 4d 6f 76 65 4c 61 73 | 74 28 29 0d 0a 20 20 20 |.MoveLas|t().. |
|00002c60| 20 5b 54 61 72 67 65 74 | 5d 2e 4d 6f 76 65 28 2d | [Target|].Move(-|
|00002c70| 28 43 49 6e 74 28 5b 50 | 61 67 65 53 69 7a 65 5d |(CInt([P|ageSize]|
|00002c80| 29 2d 31 29 29 0d 0a 45 | 6e 64 20 49 66 01 00 3e |)-1))..E|nd If..>|
|00002c90| 80 05 00 00 00 08 50 61 | 67 65 53 69 7a 65 02 00 |......Pa|geSize..|
|00002ca0| 00 00 03 00 01 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002cb0| 00 00 00 13 44 61 74 61 | 62 61 73 65 20 6e 61 76 |....Data|base nav|
|00002cc0| 69 67 61 74 69 6f 6e 00 | 00 00 00 00 00 04 00 00 |igation.|........|
|00002cd0| 00 01 00 00 00 05 00 0b | 80 04 00 00 00 06 49 6e |........|......In|
|00002ce0| 6c 69 6e 65 00 00 00 00 | 0b 80 04 00 00 00 08 6f |line....|.......o|
|00002cf0| 6e 55 6e 4c 6f 61 64 01 | 00 00 00 00 00 00 00 00 |nUnLoad.|........|
|00002d00| 0b 80 04 00 00 00 06 53 | 65 72 76 65 72 02 00 00 |.......S|erver...|
|00002d10| 00 00 00 00 00 00 01 00 | 00 00 00 0b 80 04 00 00 |........|........|
|00002d20| 00 00 01 00 00 00 00 00 | 00 00 00 0b 80 04 00 00 |........|........|
|00002d30| 00 06 6f 6e 42 6c 75 72 | 01 00 00 00 00 00 00 00 |..onBlur|........|
|00002d40| 00 bd 44 f9 fc b5 49 d2 | 11 90 c2 00 60 08 8f 47 |..D...I.|....`..G|
|00002d50| c4 01 00 00 00 24 33 37 | 37 41 43 34 33 30 2d 36 |.....$37|7AC430-6|
|00002d60| 32 31 31 2d 31 31 44 32 | 2d 38 31 31 37 2d 30 30 |211-11D2|-8117-00|
|00002d70| 36 30 30 38 43 38 36 43 | 32 35 03 33 2e 30 ff f5 |6008C86C|25.3.0..|
|00002d80| 02 56 31 30 5f 33 30 0d | 0a 0d 0a 4e 6f 74 65 3a |.V10_30.|...Note:|
|00002d90| 20 74 68 69 73 20 63 6f | 6e 74 72 61 63 74 20 69 | this co|ntract i|
|00002da0| 73 20 75 73 65 64 20 62 | 79 20 74 68 65 20 44 61 |s used b|y the Da|
|00002db0| 74 61 46 6f 72 6d 20 57 | 69 7a 61 72 64 2c 20 6d |taForm W|izard, m|
|00002dc0| 6f 64 69 66 69 63 61 74 | 69 6f 6e 73 20 61 72 65 |odificat|ions are|
|00002dd0| 20 6e 6f 74 20 72 65 63 | 6f 6d 6d 65 6e 64 65 64 | not rec|ommended|
|00002de0| 2e 20 20 49 66 20 79 6f | 75 20 77 6f 75 6c 64 20 |. If yo|u would |
|00002df0| 6c 69 6b 65 20 74 6f 20 | 6d 6f 64 69 66 79 20 69 |like to |modify i|
|00002e00| 74 2c 20 63 72 65 61 74 | 65 20 61 6e 64 20 6d 6f |t, creat|e and mo|
|00002e10| 64 69 66 79 20 61 20 63 | 6f 70 79 20 74 6f 20 72 |dify a c|opy to r|
|00002e20| 65 74 61 69 6e 20 74 68 | 65 20 6f 72 69 67 69 6e |etain th|e origin|
|00002e30| 61 6c 2e 0d 0a 0d 0a 54 | 68 69 73 20 63 6f 6e 74 |al.....T|his cont|
|00002e40| 72 61 63 74 20 69 73 20 | 61 6e 20 69 6e 74 65 72 |ract is |an inter|
|00002e50| 61 63 74 69 6f 6e 20 62 | 65 74 77 65 65 6e 20 61 |action b|etween a|
|00002e60| 20 73 75 62 6d 69 74 20 | 62 75 74 74 6f 6e 20 28 | submit |button (|
|00002e70| 73 6f 75 72 63 65 29 20 | 61 6e 64 20 61 20 72 65 |source) |and a re|
|00002e80| 63 6f 72 64 73 65 74 20 | 28 74 61 72 67 65 74 29 |cordset |(target)|
|00002e90| 2e 20 20 49 74 20 69 73 | 20 69 6e 74 65 6e 64 65 |. It is| intende|
|00002ea0| 64 20 66 6f 72 20 75 73 | 65 20 77 69 74 68 20 74 |d for us|e with t|
|00002eb0| 68 65 20 6c 6f 6f 70 65 | 72 20 53 6d 61 72 74 20 |he loope|r Smart |
|00002ec0| 65 6c 65 6d 65 6e 74 20 | 61 6e 64 20 64 6f 65 73 |element |and does|
|00002ed0| 20 6e 6f 74 20 63 75 72 | 72 65 6e 74 6c 79 20 77 | not cur|rently w|
|00002ee0| 6f 72 6b 20 77 69 74 68 | 20 74 68 65 20 41 75 74 |ork with| the Aut|
|00002ef0| 6f 54 61 62 6c 65 2e 20 | 20 43 6c 69 63 6b 69 6e |oTable. | Clickin|
|00002f00| 67 20 74 68 65 20 62 75 | 74 74 6f 6e 20 6d 6f 76 |g the bu|tton mov|
|00002f10| 65 73 20 74 6f 20 74 68 | 65 20 6c 61 73 74 20 73 |es to th|e last s|
|00002f20| 65 74 20 6f 66 20 72 65 | 63 6f 72 64 73 20 69 6e |et of re|cords in|
|00002f30| 20 74 68 65 20 72 65 63 | 6f 72 64 73 65 74 20 73 | the rec|ordset s|
|00002f40| 6f 75 72 63 65 20 61 6e | 64 20 75 70 64 61 74 65 |ource an|d update|
|00002f50| 73 20 74 68 65 20 64 69 | 73 70 6c 61 79 65 64 20 |s the di|splayed |
|00002f60| 72 65 63 6f 72 64 73 20 | 69 6e 20 74 68 65 20 6c |records |in the l|
|00002f70| 6f 6f 70 65 72 20 62 6f | 75 6e 64 20 74 6f 20 74 |ooper bo|und to t|
|00002f80| 68 65 20 72 65 63 6f 72 | 64 20 73 6f 75 72 63 65 |he recor|d source|
|00002f90| 2e 20 20 49 6e 63 72 65 | 6d 65 6e 74 69 6e 67 20 |. Incre|menting |
|00002fa0| 74 68 65 20 73 65 74 20 | 6f 66 20 72 65 63 6f 72 |the set |of recor|
|00002fb0| 64 73 20 69 73 20 63 6f | 6e 74 72 6f 6c 6c 65 64 |ds is co|ntrolled|
|00002fc0| 20 77 69 74 68 20 74 68 | 65 20 70 61 67 65 20 73 | with th|e page s|
|00002fd0| 69 7a 65 20 70 61 72 61 | 6d 65 74 65 72 2c 20 77 |ize para|meter, w|
|00002fe0| 68 69 63 68 20 73 70 65 | 63 69 66 69 65 73 20 68 |hich spe|cifies h|
|00002ff0| 6f 77 20 6d 61 6e 79 20 | 72 65 63 6f 72 64 73 20 |ow many |records |
|00003000| 61 72 65 20 61 73 73 6f | 63 69 61 74 65 64 20 77 |are asso|ciated w|
|00003010| 69 74 68 20 74 68 65 20 | 22 73 65 74 2e 22 0d 0a |ith the |"set."..|
|00003020| 0d 0a 53 65 65 20 44 61 | 74 61 62 61 73 65 4e 61 |..See Da|tabaseNa|
|00003030| 76 69 67 61 74 69 6f 6e | 2e 64 6f 63 20 66 6f 72 |vigation|.doc for|
|00003040| 20 67 65 6e 65 72 61 6c | 20 69 6e 66 6f 72 6d 61 | general| informa|
|00003050| 74 69 6f 6e 20 6f 6e 20 | 44 61 74 61 62 61 73 65 |tion on |Database|
|00003060| 20 6e 61 76 69 67 61 74 | 69 6f 6e 20 63 6f 6e 74 | navigat|ion cont|
|00003070| 72 61 63 74 73 2e 05 80 | 12 00 00 00 4c 44 69 73 |racts...|....LDis|
|00003080| 70 6c 61 79 20 6e 65 78 | 74 20 73 65 74 20 6f 66 |play nex|t set of|
|00003090| 20 72 65 63 6f 72 64 73 | 20 66 72 6f 6d 20 5b 74 | records| from [t|
|000030a0| 61 72 67 65 74 5d 20 69 | 6e 20 4c 6f 6f 70 65 72 |arget] i|n Looper|
|000030b0| 20 77 68 65 6e 20 5b 73 | 6f 75 72 63 65 5d 20 69 | when [s|ource] i|
|000030c0| 73 20 63 6c 69 63 6b 65 | 64 00 00 00 00 00 02 00 |s clicke|d.......|
|000030d0| 07 80 01 00 00 00 06 53 | 6f 75 72 63 65 01 00 09 |.......S|ource...|
|000030e0| 80 03 00 00 00 00 00 00 | 00 07 6f 6e 43 6c 69 63 |........|..onClic|
|000030f0| 6b 01 00 0b 80 04 00 00 | 00 07 6f 6e 43 6c 69 63 |k.......|..onClic|
|00003100| 6b 01 00 00 00 00 00 00 | 00 00 07 80 01 00 00 00 |k.......|........|
|00003110| 06 54 61 72 67 65 74 01 | 00 09 80 03 00 00 00 01 |.Target.|........|
|00003120| 00 00 00 0b 4d 6f 76 65 | 46 69 72 73 74 28 29 00 |....Move|First().|
|00003130| 00 01 00 3e 80 05 00 00 | 00 08 50 61 67 65 53 69 |...>....|..PageSi|
|00003140| 7a 65 02 00 00 00 03 00 | 01 00 00 00 00 00 00 00 |ze......|........|
|00003150| 00 00 00 00 00 00 00 13 | 44 61 74 61 62 61 73 65 |........|Database|
|00003160| 20 6e 61 76 69 67 61 74 | 69 6f 6e 00 00 00 00 00 | navigat|ion.....|
|00003170| 00 04 00 00 00 01 00 00 | 00 05 00 0b 80 04 00 00 |........|........|
|00003180| 00 06 49 6e 6c 69 6e 65 | 00 00 00 00 0b 80 04 00 |..Inline|........|
|00003190| 00 00 08 6f 6e 55 6e 4c | 6f 61 64 01 00 00 00 00 |...onUnL|oad.....|
|000031a0| 00 00 00 00 0b 80 04 00 | 00 00 06 53 65 72 76 65 |........|...Serve|
|000031b0| 72 02 00 00 00 00 00 00 | 00 44 69 66 20 28 52 65 |r.......|.Dif (Re|
|000031c0| 71 75 65 73 74 2e 46 6f | 72 6d 2e 4b 65 79 28 22 |quest.Fo|rm.Key("|
|000031d0| 5b 53 6f 75 72 63 65 5d | 22 29 20 21 3d 20 22 22 |[Source]|") != ""|
|000031e0| 29 20 0d 0a 7b 0d 0a 20 | 2f 2f 4e 6f 20 69 6d 70 |) ..{.. |//No imp|
|000031f0| 6c 65 6d 65 6e 74 61 74 | 69 6f 6e 0d 0a 7d 01 00 |lementat|ion..}..|
|00003200| 00 00 4a 69 66 20 52 65 | 71 75 65 73 74 2e 46 6f |..Jif Re|quest.Fo|
|00003210| 72 6d 2e 4b 65 79 28 22 | 5b 53 6f 75 72 63 65 5d |rm.Key("|[Source]|
|00003220| 22 29 20 3c 3e 20 22 22 | 20 74 68 65 6e 0d 0a 20 |") <> ""| then.. |
|00003230| 52 65 6d 20 4e 6f 20 69 | 6d 70 6c 65 6d 65 6e 74 |Rem No i|mplement|
|00003240| 61 74 69 6f 6e 0d 0a 45 | 6e 64 20 49 66 0b 80 04 |ation..E|nd If...|
|00003250| 00 00 00 00 01 00 00 00 | 00 00 00 00 00 0b 80 04 |........|........|
|00003260| 00 00 00 06 6f 6e 42 6c | 75 72 01 00 00 00 00 00 |....onBl|ur......|
|00003270| 00 00 00 bb 3f a6 d5 cc | 49 d2 11 90 c2 00 60 08 |....?...|I.....`.|
|00003280| 8f 47 c4 01 00 00 00 24 | 33 37 37 41 43 34 33 30 |.G.....$|377AC430|
|00003290| 2d 36 32 31 31 2d 31 31 | 44 32 2d 38 31 31 37 2d |-6211-11|D2-8117-|
|000032a0| 30 30 36 30 30 38 43 38 | 36 43 32 35 03 33 2e 30 |006008C8|6C25.3.0|
|000032b0| ff f5 02 56 31 30 5f 33 | 30 0d 0a 0d 0a 4e 6f 74 |...V10_3|0....Not|
|000032c0| 65 3a 20 74 68 69 73 20 | 63 6f 6e 74 72 61 63 74 |e: this |contract|
|000032d0| 20 69 73 20 75 73 65 64 | 20 62 79 20 74 68 65 20 | is used| by the |
|000032e0| 44 61 74 61 46 6f 72 6d | 20 57 69 7a 61 72 64 2c |DataForm| Wizard,|
|000032f0| 20 6d 6f 64 69 66 69 63 | 61 74 69 6f 6e 73 20 61 | modific|ations a|
|00003300| 72 65 20 6e 6f 74 20 72 | 65 63 6f 6d 6d 65 6e 64 |re not r|ecommend|
|00003310| 65 64 2e 20 20 49 66 20 | 79 6f 75 20 77 6f 75 6c |ed. If |you woul|
|00003320| 64 20 6c 69 6b 65 20 74 | 6f 20 6d 6f 64 69 66 79 |d like t|o modify|
|00003330| 20 69 74 2c 20 63 72 65 | 61 74 65 20 61 6e 64 20 | it, cre|ate and |
|00003340| 6d 6f 64 69 66 79 20 61 | 20 63 6f 70 79 20 74 6f |modify a| copy to|
|00003350| 20 72 65 74 61 69 6e 20 | 74 68 65 20 6f 72 69 67 | retain |the orig|
|00003360| 69 6e 61 6c 2e 0d 0a 0d | 0a 54 68 69 73 20 63 6f |inal....|.This co|
|00003370| 6e 74 72 61 63 74 20 69 | 73 20 61 6e 20 69 6e 74 |ntract i|s an int|
|00003380| 65 72 61 63 74 69 6f 6e | 20 62 65 74 77 65 65 6e |eraction| between|
|00003390| 20 61 20 73 75 62 6d 69 | 74 20 62 75 74 74 6f 6e | a submi|t button|
|000033a0| 20 28 73 6f 75 72 63 65 | 29 20 61 6e 64 20 61 20 | (source|) and a |
|000033b0| 72 65 63 6f 72 64 73 65 | 74 20 28 74 61 72 67 65 |recordse|t (targe|
|000033c0| 74 29 2e 20 20 49 74 20 | 69 73 20 69 6e 74 65 6e |t). It |is inten|
|000033d0| 64 65 64 20 66 6f 72 20 | 75 73 65 20 77 69 74 68 |ded for |use with|
|000033e0| 20 74 68 65 20 6c 6f 6f | 70 65 72 20 53 6d 61 72 | the loo|per Smar|
|000033f0| 74 20 65 6c 65 6d 65 6e | 74 20 61 6e 64 20 64 6f |t elemen|t and do|
|00003400| 65 73 20 6e 6f 74 20 63 | 75 72 72 65 6e 74 6c 79 |es not c|urrently|
|00003410| 20 77 6f 72 6b 20 77 69 | 74 68 20 74 68 65 20 41 | work wi|th the A|
|00003420| 75 74 6f 54 61 62 6c 65 | 2e 20 20 43 6c 69 63 6b |utoTable|. Click|
|00003430| 69 6e 67 20 74 68 65 20 | 62 75 74 74 6f 6e 20 6d |ing the |button m|
|00003440| 6f 76 65 73 20 74 6f 20 | 74 68 65 20 6e 65 78 74 |oves to |the next|
|00003450| 20 73 65 74 20 6f 66 20 | 72 65 63 6f 72 64 73 20 | set of |records |
|00003460| 69 6e 20 74 68 65 20 72 | 65 63 6f 72 64 73 65 74 |in the r|ecordset|
|00003470| 20 73 6f 75 72 63 65 20 | 61 6e 64 20 75 70 64 61 | source |and upda|
|00003480| 74 65 73 20 74 68 65 20 | 64 69 73 70 6c 61 79 65 |tes the |displaye|
|00003490| 64 20 72 65 63 6f 72 64 | 73 20 69 6e 20 74 68 65 |d record|s in the|
|000034a0| 20 6c 6f 6f 70 65 72 20 | 62 6f 75 6e 64 20 74 6f | looper |bound to|
|000034b0| 20 74 68 65 20 72 65 63 | 6f 72 64 20 73 6f 75 72 | the rec|ord sour|
|000034c0| 63 65 2e 20 20 49 6e 63 | 72 65 6d 65 6e 74 69 6e |ce. Inc|rementin|
|000034d0| 67 20 74 68 65 20 73 65 | 74 20 6f 66 20 72 65 63 |g the se|t of rec|
|000034e0| 6f 72 64 73 20 69 73 20 | 63 6f 6e 74 72 6f 6c 6c |ords is |controll|
|000034f0| 65 64 20 77 69 74 68 20 | 74 68 65 20 70 61 67 65 |ed with |the page|
|00003500| 20 73 69 7a 65 20 70 61 | 72 61 6d 65 74 65 72 2c | size pa|rameter,|
|00003510| 20 77 68 69 63 68 20 73 | 70 65 63 69 66 69 65 73 | which s|pecifies|
|00003520| 20 68 6f 77 20 6d 61 6e | 79 20 72 65 63 6f 72 64 | how man|y record|
|00003530| 73 20 61 72 65 20 61 73 | 73 6f 63 69 61 74 65 64 |s are as|sociated|
|00003540| 20 77 69 74 68 20 74 68 | 65 20 22 73 65 74 2e 22 | with th|e "set."|
|00003550| 0d 0a 0d 0a 53 65 65 20 | 44 61 74 61 62 61 73 65 |....See |Database|
|00003560| 4e 61 76 69 67 61 74 69 | 6f 6e 2e 64 6f 63 20 66 |Navigati|on.doc f|
|00003570| 6f 72 20 67 65 6e 65 72 | 61 6c 20 69 6e 66 6f 72 |or gener|al infor|
|00003580| 6d 61 74 69 6f 6e 20 6f | 6e 20 44 61 74 61 62 61 |mation o|n Databa|
|00003590| 73 65 20 6e 61 76 69 67 | 61 74 69 6f 6e 20 63 6f |se navig|ation co|
|000035a0| 6e 74 72 61 63 74 73 2e | 05 80 12 00 00 00 00 01 |ntracts.|........|
|000035b0| 00 00 00 35 44 6f 20 6e | 6f 74 20 61 6c 6c 6f 77 |...5Do n|ot allow|
|000035c0| 20 6e 61 76 69 67 61 74 | 69 6f 6e 20 70 61 73 74 | navigat|ion past|
|000035d0| 20 74 68 65 20 65 6e 64 | 20 6f 66 20 74 68 65 20 | the end| of the |
|000035e0| 72 65 63 6f 72 64 73 65 | 74 01 00 07 80 01 00 00 |recordse|t.......|
|000035f0| 00 06 73 6f 75 72 63 65 | 03 00 09 80 03 00 00 00 |..source|........|
|00003600| 00 00 00 00 08 53 65 72 | 76 65 72 28 29 09 80 03 |.....Ser|ver()...|
|00003610| 00 00 00 00 00 00 00 0c | 42 65 66 6f 72 65 4f 70 |........|BeforeOp|
|00003620| 65 6e 28 29 09 80 03 00 | 00 00 01 00 00 00 0b 4d |en()....|.......M|
|00003630| 6f 76 65 46 69 72 73 74 | 28 29 01 00 0b 80 04 00 |oveFirst|()......|
|00003640| 00 00 08 53 65 72 76 65 | 72 28 29 02 00 00 00 00 |...Serve|r().....|
|00003650| 00 00 00 5d 69 66 20 28 | 5b 73 6f 75 72 63 65 5d |...]if (|[source]|
|00003660| 2e 49 73 42 4f 46 28 29 | 29 0d 0a 20 20 5b 73 6f |.IsBOF()|).. [so|
|00003670| 75 72 63 65 5d 2e 4d 6f | 76 65 46 69 72 73 74 28 |urce].Mo|veFirst(|
|00003680| 29 3b 0d 0a 69 66 20 28 | 5b 73 6f 75 72 63 65 5d |);..if (|[source]|
|00003690| 2e 49 73 45 4f 46 28 29 | 29 0d 0a 20 20 5b 73 6f |.IsEOF()|).. [so|
|000036a0| 75 72 63 65 5d 2e 4d 6f | 76 65 4c 61 73 74 28 29 |urce].Mo|veLast()|
|000036b0| 3b 01 00 00 00 89 69 66 | 20 28 5b 73 6f 75 72 63 |;.....if| ([sourc|
|000036c0| 65 5d 2e 47 65 74 41 62 | 73 50 6f 73 28 29 20 3d |e].GetAb|sPos() =|
|000036d0| 20 22 42 4f 46 22 29 20 | 74 68 65 6e 0d 0a 20 20 | "BOF") |then.. |
|000036e0| 5b 73 6f 75 72 63 65 5d | 2e 4d 6f 76 65 46 69 72 |[source]|.MoveFir|
|000036f0| 73 74 28 29 0d 0a 65 6c | 73 65 69 66 20 28 5b 73 |st()..el|seif ([s|
|00003700| 6f 75 72 63 65 5d 2e 47 | 65 74 41 62 73 50 6f 73 |ource].G|etAbsPos|
|00003710| 28 29 20 3d 20 22 45 4f | 46 22 29 20 74 68 65 6e |() = "EO|F") then|
|00003720| 0d 0a 20 20 5b 73 6f 75 | 72 63 65 5d 2e 4d 6f 76 |.. [sou|rce].Mov|
|00003730| 65 4c 61 73 74 28 29 0d | 0a 65 6e 64 20 69 66 00 |eLast().|.end if.|
|00003740| 00 13 44 61 74 61 62 61 | 73 65 20 6e 61 76 69 67 |..Databa|se navig|
|00003750| 61 74 69 6f 6e 00 00 00 | 00 00 00 04 00 00 00 01 |ation...|........|
|00003760| 00 00 00 00 00 85 4c 5c | 3c d3 4d d2 11 80 4b 00 |......L\|<.M...K.|
|00003770| 60 08 d0 5a 6a 01 00 00 | 00 24 33 37 37 41 43 34 |`..Zj...|.$377AC4|
|00003780| 33 30 2d 36 32 31 31 2d | 31 31 44 32 2d 38 31 31 |30-6211-|11D2-811|
|00003790| 37 2d 30 30 36 30 30 38 | 43 38 36 43 32 35 03 33 |7-006008|C86C25.3|
|000037a0| 2e 30 7d 41 20 73 69 6e | 67 6c 65 20 65 6c 65 6d |.0}A sin|gle elem|
|000037b0| 65 6e 74 20 63 6f 6e 74 | 72 61 63 74 20 61 70 70 |ent cont|ract app|
|000037c0| 6c 69 65 64 20 6f 74 20 | 61 20 72 65 63 6f 72 64 |lied ot |a record|
|000037d0| 73 65 74 20 74 68 61 74 | 20 70 72 65 76 65 6e 74 |set that| prevent|
|000037e0| 73 20 6e 61 76 69 67 61 | 74 69 6f 6e 20 70 61 73 |s naviga|tion pas|
|000037f0| 74 20 74 68 65 20 62 65 | 67 69 6e 6e 69 6e 67 20 |t the be|ginning |
|00003800| 6f 72 20 65 6e 64 20 6f | 66 20 61 20 72 65 63 6f |or end o|f a reco|
|00003810| 72 64 73 65 74 2e 0d 0a | 0d 0a 56 31 30 5f 33 30 |rdset...|..V10_30|
|00003820| 05 80 12 00 00 00 3a 4e | 61 76 69 67 61 74 65 20 |......:N|avigate |
|00003830| 5b 74 61 72 67 65 74 5d | 20 77 68 65 6e 20 5b 73 |[target]| when [s|
|00003840| 6f 75 72 63 65 5d 20 69 | 73 20 63 6c 69 63 6b 65 |ource] i|s clicke|
|00003850| 64 20 61 6e 64 20 73 75 | 62 6d 69 74 20 66 6f 72 |d and su|bmit for|
|00003860| 6d 00 00 00 00 00 02 00 | 07 80 01 00 00 00 06 53 |m.......|.......S|
|00003870| 6f 75 72 63 65 04 00 09 | 80 03 00 00 00 00 00 00 |ource...|........|
|00003880| 00 07 6f 6e 46 69 72 73 | 74 09 80 03 00 00 00 00 |..onFirs|t.......|
|00003890| 00 00 00 06 6f 6e 4c 61 | 73 74 09 80 03 00 00 00 |....onLa|st......|
|000038a0| 00 00 00 00 06 6f 6e 4e | 65 78 74 09 80 03 00 00 |.....onN|ext.....|
|000038b0| 00 00 00 00 00 06 6f 6e | 50 72 65 76 04 00 0b 80 |......on|Prev....|
|000038c0| 04 00 00 00 06 6f 6e 50 | 72 65 76 01 00 00 00 00 |.....onP|rev.....|
|000038d0| 00 00 00 4e 76 61 72 20 | 66 6f 72 6d 20 3d 20 67 |...Nvar |form = g|
|000038e0| 65 74 46 6f 72 6d 28 29 | 3b 0d 0a 0d 0a 5b 74 61 |etForm()|;....[ta|
|000038f0| 72 67 65 74 5d 2e 4d 6f | 76 65 50 72 65 76 69 6f |rget].Mo|vePrevio|
|00003900| 75 73 28 29 3b 0d 0a 69 | 66 20 28 66 6f 72 6d 29 |us();..i|f (form)|
|00003910| 0d 0a 20 20 66 6f 72 6d | 2e 73 75 62 6d 69 74 28 |.. form|.submit(|
|00003920| 29 3b 0b 80 04 00 00 00 | 06 6f 6e 4e 65 78 74 01 |);......|.onNext.|
|00003930| 00 00 00 00 00 00 00 4a | 76 61 72 20 66 6f 72 6d |.......J|var form|
|00003940| 20 3d 20 67 65 74 46 6f | 72 6d 28 29 3b 0d 0a 0d | = getFo|rm();...|
|00003950| 0a 5b 74 61 72 67 65 74 | 5d 2e 4d 6f 76 65 4e 65 |.[target|].MoveNe|
|00003960| 78 74 28 29 3b 0d 0a 69 | 66 20 28 66 6f 72 6d 29 |xt();..i|f (form)|
|00003970| 0d 0a 20 20 66 6f 72 6d | 2e 73 75 62 6d 69 74 28 |.. form|.submit(|
|00003980| 29 3b 0b 80 04 00 00 00 | 06 6f 6e 4c 61 73 74 01 |);......|.onLast.|
|00003990| 00 00 00 00 00 00 00 4a | 76 61 72 20 66 6f 72 6d |.......J|var form|
|000039a0| 20 3d 20 67 65 74 46 6f | 72 6d 28 29 3b 0d 0a 0d | = getFo|rm();...|
|000039b0| 0a 5b 74 61 72 67 65 74 | 5d 2e 4d 6f 76 65 4c 61 |.[target|].MoveLa|
|000039c0| 73 74 28 29 3b 0d 0a 69 | 66 20 28 66 6f 72 6d 29 |st();..i|f (form)|
|000039d0| 0d 0a 20 20 66 6f 72 6d | 2e 73 75 62 6d 69 74 28 |.. form|.submit(|
|000039e0| 29 3b 0b 80 04 00 00 00 | 07 6f 6e 46 69 72 73 74 |);......|.onFirst|
|000039f0| 01 00 00 00 00 00 00 00 | 4b 76 61 72 20 66 6f 72 |........|Kvar for|
|00003a00| 6d 20 3d 20 67 65 74 46 | 6f 72 6d 28 29 3b 0d 0a |m = getF|orm();..|
|00003a10| 0d 0a 5b 74 61 72 67 65 | 74 5d 2e 4d 6f 76 65 46 |..[targe|t].MoveF|
|00003a20| 69 72 73 74 28 29 3b 0d | 0a 69 66 20 28 66 6f 72 |irst();.|.if (for|
|00003a30| 6d 29 0d 0a 20 20 66 6f | 72 6d 2e 73 75 62 6d 69 |m).. fo|rm.submi|
|00003a40| 74 28 29 3b 07 80 01 00 | 00 00 06 54 61 72 67 65 |t();....|...Targe|
|00003a50| 74 04 00 09 80 03 00 00 | 00 01 00 00 00 0b 4d 6f |t.......|......Mo|
|00003a60| 76 65 46 69 72 73 74 28 | 29 09 80 03 00 00 00 01 |veFirst(|).......|
|00003a70| 00 00 00 0a 4d 6f 76 65 | 4c 61 73 74 28 29 09 80 |....Move|Last()..|
|00003a80| 03 00 00 00 01 00 00 00 | 0a 4d 6f 76 65 4e 65 78 |........|.MoveNex|
|00003a90| 74 28 29 09 80 03 00 00 | 00 01 00 00 00 0e 4d 6f |t().....|......Mo|
|00003aa0| 76 65 50 72 65 76 69 6f | 75 73 28 29 00 00 00 00 |vePrevio|us()....|
|00003ab0| 13 44 61 74 61 62 61 73 | 65 20 6e 61 76 69 67 61 |.Databas|e naviga|
|00003ac0| 74 69 6f 6e 01 00 eb 45 | 94 79 c0 7f d2 11 b8 68 |tion...E|.y.....h|
|00003ad0| 00 60 08 3e 34 a5 00 00 | 00 00 03 00 00 00 01 00 |.`.>4...|........|
|00003ae0| 00 00 00 00 a8 43 66 b6 | 19 f8 d1 11 8c b3 00 60 |.....Cf.|.......`|
|00003af0| 08 3e 34 a5 00 00 00 00 | 00 00 ff a4 01 56 31 30 |.>4.....|.....V10|
|00003b00| 5f 33 30 0d 0a 0d 0a 41 | 6c 6c 6f 77 73 20 69 6e |_30....A|llows in|
|00003b10| 74 65 72 61 63 74 69 6f | 6e 20 6f 66 20 61 20 72 |teractio|n of a r|
|00003b20| 65 63 6f 72 64 73 65 74 | 20 28 74 61 72 67 65 74 |ecordset| (target|
|00003b30| 29 20 77 69 74 68 20 61 | 6e 20 69 6e 74 65 67 72 |) with a|n integr|
|00003b40| 61 74 65 64 20 6e 61 76 | 69 67 61 74 69 6f 6e 20 |ated nav|igation |
|00003b50| 53 6d 61 72 74 45 6c 65 | 6d 65 6e 74 20 28 73 6f |SmartEle|ment (so|
|00003b60| 75 72 63 65 29 2c 20 65 | 6e 61 62 6c 69 6e 67 20 |urce), e|nabling |
|00003b70| 74 68 65 20 53 6d 61 72 | 74 45 6c 65 6d 65 6e 74 |the Smar|tElement|
|00003b80| 20 74 6f 20 6e 61 76 69 | 67 61 74 65 20 74 68 65 | to navi|gate the|
|00003b90| 20 73 6f 75 72 63 65 27 | 73 20 72 65 63 6f 72 64 | source'|s record|
|00003ba0| 73 20 61 6e 64 20 75 70 | 64 61 74 65 20 74 68 65 |s and up|date the|
|00003bb0| 20 64 69 73 70 6c 61 79 | 20 6f 66 20 61 20 66 6f | display| of a fo|
|00003bc0| 72 6d 20 62 6f 75 6e 64 | 20 74 6f 20 74 68 65 20 |rm bound| to the |
|00003bd0| 72 65 63 6f 72 64 73 65 | 74 2e 20 20 50 6f 74 65 |recordse|t. Pote|
|00003be0| 6e 74 69 61 6c 20 73 6f | 75 72 63 65 73 20 69 6e |ntial so|urces in|
|00003bf0| 63 6c 75 64 65 20 74 68 | 65 20 44 48 54 4d 4c 52 |clude th|e DHTMLR|
|00003c00| 65 63 6f 72 64 73 65 74 | 4e 61 76 69 67 61 74 69 |ecordset|Navigati|
|00003c10| 6f 6e 20 61 6e 64 20 74 | 68 65 20 52 65 63 6f 72 |on and t|he Recor|
|00003c20| 64 73 65 74 4e 61 76 69 | 67 61 74 69 6f 6e 53 63 |dsetNavi|gationSc|
|00003c30| 72 69 70 74 6c 65 74 20 | 53 6d 61 72 74 45 6c 65 |riptlet |SmartEle|
|00003c40| 6d 65 6e 74 73 2e 20 20 | 0d 0a 0d 0a 53 65 65 20 |ments. |....See |
|00003c50| 44 61 74 61 62 61 73 65 | 4e 61 76 69 67 61 74 69 |Database|Navigati|
|00003c60| 6f 6e 2e 64 6f 63 20 66 | 6f 72 20 67 65 6e 65 72 |on.doc f|or gener|
|00003c70| 61 6c 20 69 6e 66 6f 72 | 6d 61 74 69 6f 6e 20 6f |al infor|mation o|
|00003c80| 6e 20 44 61 74 61 62 61 | 73 65 20 6e 61 76 69 67 |n Databa|se navig|
|00003c90| 61 74 69 6f 6e 20 63 6f | 6e 74 72 61 63 74 73 2e |ation co|ntracts.|
|00003ca0| 20 05 80 12 00 00 00 00 | 01 00 00 00 1e 52 65 64 | .......|.....Red|
|00003cb0| 69 72 65 63 74 20 69 66 | 20 52 65 63 6f 72 64 73 |irect if| Records|
|00003cc0| 65 74 20 69 73 20 65 6d | 70 74 79 01 00 07 80 01 |et is em|pty.....|
|00003cd0| 00 00 00 06 73 6f 75 72 | 63 65 02 00 09 80 03 00 |....sour|ce......|
|00003ce0| 00 00 00 00 00 00 08 53 | 65 72 76 65 72 28 29 09 |.......S|erver().|
|00003cf0| 80 03 00 00 00 01 00 00 | 00 0b 4d 6f 76 65 46 69 |........|..MoveFi|
|00003d00| 72 73 74 28 29 01 00 0b | 80 04 00 00 00 08 53 65 |rst()...|......Se|
|00003d10| 72 76 65 72 28 29 02 00 | 00 00 00 00 00 00 53 69 |rver()..|......Si|
|00003d20| 66 20 28 5b 73 6f 75 72 | 63 65 5d 2e 49 73 42 4f |f ([sour|ce].IsBO|
|00003d30| 46 28 29 20 26 26 20 5b | 73 6f 75 72 63 65 5d 2e |F() && [|source].|
|00003d40| 49 73 45 4f 46 28 29 29 | 0d 0a 20 20 52 65 73 70 |IsEOF())|.. Resp|
|00003d50| 6f 6e 73 65 2e 52 65 64 | 69 72 65 63 74 28 65 73 |onse.Red|irect(es|
|00003d60| 63 61 70 65 28 5b 50 61 | 67 65 20 4e 61 6d 65 5d |cape([Pa|ge Name]|
|00003d70| 29 29 01 00 00 00 68 69 | 66 20 28 5b 73 6f 75 72 |))....hi|f ([sour|
|00003d80| 63 65 5d 2e 52 53 2e 42 | 4f 46 20 41 6e 64 20 5b |ce].RS.B|OF And [|
|00003d90| 73 6f 75 72 63 65 5d 2e | 52 53 2e 45 4f 46 29 20 |source].|RS.EOF) |
|00003da0| 74 68 65 6e 0d 0a 20 20 | 52 65 73 70 6f 6e 73 65 |then.. |Response|
|00003db0| 2e 52 65 64 69 72 65 63 | 74 28 55 52 4c 45 73 63 |.Redirec|t(URLEsc|
|00003dc0| 61 70 65 53 70 61 63 65 | 73 28 5b 50 61 67 65 20 |apeSpace|s([Page |
|00003dd0| 4e 61 6d 65 5d 29 29 0d | 0a 65 6e 64 20 69 66 01 |Name])).|.end if.|
|00003de0| 00 3e 80 05 00 00 00 09 | 50 61 67 65 20 4e 61 6d |.>......|Page Nam|
|00003df0| 65 06 00 00 00 03 00 01 | 00 00 00 00 00 00 00 00 |e.......|........|
|00003e00| 00 00 00 00 00 00 13 44 | 61 74 61 62 61 73 65 20 |.......D|atabase |
|00003e10| 6e 61 76 69 67 61 74 69 | 6f 6e 01 00 e0 5a 9c 93 |navigati|on...Z..|
|00003e20| 23 83 d2 11 80 52 00 10 | 4b d3 38 d1 00 00 00 00 |#....R..|K.8.....|
|00003e30| 04 00 00 00 01 00 00 00 | 02 00 0b 80 04 00 00 00 |........|........|
|00003e40| 06 53 65 72 76 65 72 01 | 00 00 00 00 00 00 00 00 |.Server.|........|
|00003e50| 0b 80 04 00 00 00 06 6f | 6e 42 6c 75 72 01 00 00 |.......o|nBlur...|
|00003e60| 00 00 00 00 00 00 3e a5 | 89 a8 4c 59 d2 11 80 59 |......>.|..LY...Y|
|00003e70| 00 60 08 d0 5a 6a 01 00 | 00 00 24 33 37 37 41 43 |.`..Zj..|..$377AC|
|00003e80| 34 33 30 2d 36 32 31 31 | 2d 31 31 44 32 2d 38 31 |430-6211|-11D2-81|
|00003e90| 31 37 2d 30 30 36 30 30 | 38 43 38 36 43 32 35 03 |17-00600|8C86C25.|
|00003ea0| 33 2e 30 db 41 20 73 69 | 6e 67 6c 65 20 65 6c 65 |3.0.A si|ngle ele|
|00003eb0| 6d 65 6e 74 20 63 6f 6e | 74 72 61 63 74 20 6f 6e |ment con|tract on|
|00003ec0| 20 61 20 72 65 63 6f 72 | 64 73 65 74 20 74 68 61 | a recor|dset tha|
|00003ed0| 74 20 6e 61 76 69 67 61 | 74 65 73 20 74 6f 20 61 |t naviga|tes to a|
|00003ee0| 6e 6f 74 68 65 72 20 70 | 61 67 65 20 69 66 20 74 |nother p|age if t|
|00003ef0| 68 65 20 72 65 63 6f 72 | 64 73 65 74 20 69 73 20 |he recor|dset is |
|00003f00| 65 6d 70 74 79 2e 20 20 | 54 68 69 73 20 63 61 6e |empty. |This can|
|00003f10| 20 62 65 20 75 73 65 64 | 20 74 6f 20 69 6e 66 6f | be used| to info|
|00003f20| 72 6d 20 74 68 65 20 75 | 73 65 72 20 69 66 20 74 |rm the u|ser if t|
|00003f30| 68 65 72 65 20 61 72 65 | 20 6e 6f 20 72 65 63 6f |here are| no reco|
|00003f40| 72 64 73 20 74 6f 20 64 | 69 73 70 6c 61 79 20 76 |rds to d|isplay v|
|00003f50| 69 61 20 61 20 6d 65 73 | 73 61 67 65 20 6f 6e 20 |ia a mes|sage on |
|00003f60| 74 68 65 20 72 65 64 69 | 72 65 63 74 65 64 20 70 |the redi|rected p|
|00003f70| 61 67 65 2e 0d 0a 0d 0a | 56 31 30 5f 33 30 20 05 |age.....|V10_30 .|
|00003f80| 80 12 00 00 00 49 52 65 | 70 6c 61 63 65 20 54 6f |.....IRe|place To|
|00003f90| 6b 65 6e 73 20 69 6e 20 | 5b 54 65 78 74 20 45 6c |kens in |[Text El|
|00003fa0| 65 6d 65 6e 74 5d 20 77 | 69 74 68 20 72 65 63 6f |ement] w|ith reco|
|00003fb0| 72 64 20 6e 75 6d 62 65 | 72 73 20 64 69 73 70 6c |rd numbe|rs displ|
|00003fc0| 61 79 65 64 20 69 6e 20 | 5b 54 61 62 6c 65 5d 00 |ayed in |[Table].|
|00003fd0| 00 00 00 00 03 00 07 80 | 01 00 00 00 05 54 61 62 |........|.....Tab|
|00003fe0| 6c 65 01 00 09 80 03 00 | 00 00 01 00 00 00 0a 6e |le......|.......n|
|00003ff0| 65 78 74 50 61 67 65 28 | 29 00 00 07 80 01 00 00 |extPage(|).......|
|00004000| 00 0c 54 65 78 74 20 45 | 6c 65 6d 65 6e 74 02 00 |..Text E|lement..|
|00004010| 09 80 03 00 00 00 02 00 | 00 00 09 74 65 78 74 53 |........|...textS|
|00004020| 74 79 6c 65 09 80 03 00 | 00 00 00 00 00 00 0c 53 |tyle....|.......S|
|00004030| 65 72 76 65 72 28 68 74 | 6d 6c 29 01 00 0b 80 04 |erver(ht|ml).....|
|00004040| 00 00 00 0c 53 65 72 76 | 65 72 28 68 74 6d 6c 29 |....Serv|er(html)|
|00004050| 02 00 00 00 00 00 00 00 | ff 56 01 2f 2f 20 54 68 |........|.V.// Th|
|00004060| 65 20 76 61 72 69 61 62 | 6c 65 73 20 61 72 65 20 |e variab|les are |
|00004070| 63 61 6c 63 75 6c 61 74 | 65 64 20 69 6e 20 74 68 |calculat|ed in th|
|00004080| 65 20 53 65 72 76 65 72 | 0d 0a 2f 2f 20 65 76 65 |e Server|..// eve|
|00004090| 6e 74 20 6f 66 20 74 68 | 65 20 72 65 63 6f 72 64 |nt of th|e record|
|000040a0| 73 65 74 2e 0d 0a 0d 0a | 68 74 6d 6c 20 3d 20 73 |set.....|html = s|
|000040b0| 75 62 41 77 69 74 68 42 | 69 6e 43 28 5b 54 6f 70 |ubAwithB|inC([Top|
|000040c0| 20 52 65 63 6f 72 64 20 | 54 6f 6b 65 6e 5d 2c 20 | Record |Token], |
|000040d0| 5b 54 61 62 6c 65 5d 63 | 75 72 50 6f 73 2c 20 68 |[Table]c|urPos, h|
|000040e0| 74 6d 6c 29 0d 0a 68 74 | 6d 6c 20 3d 20 73 75 62 |tml)..ht|ml = sub|
|000040f0| 41 77 69 74 68 42 69 6e | 43 28 5b 42 6f 74 74 6f |AwithBin|C([Botto|
|00004100| 6d 20 52 65 63 6f 72 64 | 20 54 6f 6b 65 6e 5d 2c |m Record| Token],|
|00004110| 20 5b 54 61 62 6c 65 5d | 65 6e 64 52 65 63 2c 20 | [Table]|endRec, |
|00004120| 68 74 6d 6c 29 0d 0a 68 | 74 6d 6c 20 3d 20 73 75 |html)..h|tml = su|
|00004130| 62 41 77 69 74 68 42 69 | 6e 43 28 5b 54 6f 74 61 |bAwithBi|nC([Tota|
|00004140| 6c 20 52 65 63 6f 72 64 | 20 54 6f 6b 65 6e 5d 2c |l Record| Token],|
|00004150| 20 5b 54 61 62 6c 65 5d | 72 65 63 43 6f 75 6e 74 | [Table]|recCount|
|00004160| 2c 20 68 74 6d 6c 29 0d | 0a 0d 0a 69 66 20 28 5b |, html).|...if ([|
|00004170| 54 61 62 6c 65 5d 72 65 | 63 43 6f 75 6e 74 20 3d |Table]re|cCount =|
|00004180| 3d 20 30 29 0d 0a 7b 0d | 0a 20 20 20 20 68 74 6d |= 0)..{.|. htm|
|00004190| 6c 20 3d 20 22 22 0d 0a | 7d 0d 0a 0d 0a 52 65 73 |l = ""..|}....Res|
|000041a0| 70 6f 6e 73 65 2e 57 72 | 69 74 65 28 68 74 6d 6c |ponse.Wr|ite(html|
|000041b0| 29 01 00 00 00 ff 7c 01 | 27 20 54 68 65 20 76 61 |).....|.|' The va|
|000041c0| 72 69 61 62 6c 65 73 20 | 61 72 65 20 63 61 6c 63 |riables |are calc|
|000041d0| 75 6c 61 74 65 64 20 69 | 6e 20 74 68 65 20 53 65 |ulated i|n the Se|
|000041e0| 72 76 65 72 0d 0a 27 20 | 65 76 65 6e 74 20 6f 66 |rver..' |event of|
|000041f0| 20 74 68 65 20 72 65 63 | 6f 72 64 73 65 74 2e 0d | the rec|ordset..|
|00004200| 0a 0d 0a 68 74 6d 6c 20 | 3d 20 73 75 62 41 77 69 |...html |= subAwi|
|00004210| 74 68 42 69 6e 43 28 5b | 54 6f 70 20 52 65 63 6f |thBinC([|Top Reco|
|00004220| 72 64 20 54 6f 6b 65 6e | 5d 2c 20 74 72 69 6d 28 |rd Token|], trim(|
|00004230| 63 73 74 72 28 5b 54 61 | 62 6c 65 5d 63 75 72 50 |cstr([Ta|ble]curP|
|00004240| 6f 73 29 29 2c 20 68 74 | 6d 6c 29 0d 0a 68 74 6d |os)), ht|ml)..htm|
|00004250| 6c 20 3d 20 73 75 62 41 | 77 69 74 68 42 69 6e 43 |l = subA|withBinC|
|00004260| 28 5b 42 6f 74 74 6f 6d | 20 52 65 63 6f 72 64 20 |([Bottom| Record |
|00004270| 54 6f 6b 65 6e 5d 2c 20 | 74 72 69 6d 28 63 73 74 |Token], |trim(cst|
|00004280| 72 28 5b 54 61 62 6c 65 | 5d 65 6e 64 52 65 63 29 |r([Table|]endRec)|
|00004290| 29 2c 20 68 74 6d 6c 29 | 0d 0a 68 74 6d 6c 20 3d |), html)|..html =|
|000042a0| 20 73 75 62 41 77 69 74 | 68 42 69 6e 43 28 5b 54 | subAwit|hBinC([T|
|000042b0| 6f 74 61 6c 20 52 65 63 | 6f 72 64 20 54 6f 6b 65 |otal Rec|ord Toke|
|000042c0| 6e 5d 2c 20 74 72 69 6d | 28 63 73 74 72 28 5b 54 |n], trim|(cstr([T|
|000042d0| 61 62 6c 65 5d 72 65 63 | 43 6f 75 6e 74 29 29 2c |able]rec|Count)),|
|000042e0| 20 68 74 6d 6c 29 0d 0a | 0d 0a 69 66 20 5b 54 61 | html)..|..if [Ta|
|000042f0| 62 6c 65 5d 72 65 63 43 | 6f 75 6e 74 20 3d 20 30 |ble]recC|ount = 0|
|00004300| 20 74 68 65 6e 0d 0a 20 | 20 20 20 68 74 6d 6c 20 | then.. | html |
|00004310| 3d 20 22 22 0d 0a 65 6e | 64 20 69 66 0d 0a 0d 0a |= ""..en|d if....|
|00004320| 52 65 73 70 6f 6e 73 65 | 2e 57 72 69 74 65 28 68 |Response|.Write(h|
|00004330| 74 6d 6c 29 07 80 01 00 | 00 00 09 52 65 63 6f 72 |tml)....|...Recor|
|00004340| 64 73 65 74 03 00 09 80 | 03 00 00 00 00 00 00 00 |dset....|........|
|00004350| 0c 42 65 66 6f 72 65 4f | 70 65 6e 28 29 09 80 03 |.BeforeO|pen()...|
|00004360| 00 00 00 00 00 00 00 08 | 53 65 72 76 65 72 28 29 |........|Server()|
|00004370| 09 80 03 00 00 00 01 00 | 00 00 0b 4d 6f 76 65 46 |........|...MoveF|
|00004380| 69 72 73 74 28 29 01 00 | 0b 80 04 00 00 00 08 53 |irst()..|.......S|
|00004390| 65 72 76 65 72 28 29 02 | 00 00 00 00 00 00 00 ff |erver().|........|
|000043a0| f5 03 2f 2f 20 54 68 65 | 20 66 6f 6c 6c 6f 77 69 |..// The| followi|
|000043b0| 6e 67 20 63 6f 64 65 20 | 63 61 6c 63 75 6c 61 74 |ng code |calculat|
|000043c0| 65 73 20 74 68 65 20 74 | 6f 70 20 61 6e 64 20 62 |es the t|op and b|
|000043d0| 6f 74 74 6f 6d 20 0d 0a | 2f 2f 20 72 65 63 6f 72 |ottom ..|// recor|
|000043e0| 64 73 20 64 69 73 70 6c | 61 79 65 64 20 69 6e 20 |ds displ|ayed in |
|000043f0| 74 68 65 20 74 61 62 6c | 65 20 73 6f 20 69 74 20 |the tabl|e so it |
|00004400| 63 61 6e 0d 0a 2f 2f 20 | 62 65 20 64 69 73 70 6c |can..// |be displ|
|00004410| 61 79 65 64 20 69 6e 20 | 61 20 74 65 78 74 20 62 |ayed in |a text b|
|00004420| 6f 78 2e 0d 0a 0d 0a 5b | 54 61 62 6c 65 5d 53 74 |ox.....[|Table]St|
|00004430| 61 74 65 20 3d 20 53 74 | 72 69 6e 67 28 52 65 71 |ate = St|ring(Req|
|00004440| 75 65 73 74 28 22 5b 54 | 61 62 6c 65 5d 5f 53 74 |uest("[T|able]_St|
|00004450| 61 74 65 22 29 29 0d 0a | 5b 54 61 62 6c 65 5d 63 |ate"))..|[Table]c|
|00004460| 75 72 50 6f 73 20 3d 20 | 4e 75 6d 62 65 72 28 5b |urPos = |Number([|
|00004470| 52 65 63 6f 72 64 73 65 | 74 5d 2e 47 65 74 41 62 |Recordse|t].GetAb|
|00004480| 73 50 6f 73 28 29 29 0d | 0a 0d 0a 5b 54 61 62 6c |sPos()).|...[Tabl|
|00004490| 65 5d 70 61 67 65 53 69 | 7a 65 20 3d 20 4e 75 6d |e]pageSi|ze = Num|
|000044a0| 62 65 72 28 5b 50 61 67 | 65 53 69 7a 65 5d 29 0d |ber([Pag|eSize]).|
|000044b0| 0a 5b 54 61 62 6c 65 5d | 72 65 63 43 6f 75 6e 74 |.[Table]|recCount|
|000044c0| 20 3d 20 5b 52 65 63 6f | 72 64 73 65 74 5d 2e 52 | = [Reco|rdset].R|
|000044d0| 53 2e 52 65 63 6f 72 64 | 43 6f 75 6e 74 0d 0a 0d |S.Record|Count...|
|000044e0| 0a 69 66 20 28 5b 54 61 | 62 6c 65 5d 5f 41 63 74 |.if ([Ta|ble]_Act|
|000044f0| 69 6f 6e 20 3d 3d 20 22 | 42 61 63 6b 77 61 72 64 |ion == "|Backward|
|00004500| 22 29 0d 0a 7b 0d 0a 20 | 69 66 20 28 69 73 4e 61 |")..{.. |if (isNa|
|00004510| 4e 28 5b 54 61 62 6c 65 | 5d 63 75 72 50 6f 73 29 |N([Table|]curPos)|
|00004520| 29 0d 0a 09 7b 0d 0a 09 | 09 5b 54 61 62 6c 65 5d |)...{...|.[Table]|
|00004530| 63 75 72 50 6f 73 20 3d | 20 5b 54 61 62 6c 65 5d |curPos =| [Table]|
|00004540| 72 65 63 43 6f 75 6e 74 | 20 2d 20 5b 54 61 62 6c |recCount| - [Tabl|
|00004550| 65 5d 70 61 67 65 53 69 | 7a 65 20 2d 20 5b 54 61 |e]pageSi|ze - [Ta|
|00004560| 62 6c 65 5d 53 74 61 74 | 65 20 2b 20 31 0d 0a 09 |ble]Stat|e + 1...|
|00004570| 09 69 66 20 28 5b 54 61 | 62 6c 65 5d 63 75 72 50 |.if ([Ta|ble]curP|
|00004580| 6f 73 20 3c 3d 20 30 29 | 0d 0a 09 09 7b 0d 0a 09 |os <= 0)|....{...|
|00004590| 09 09 5b 54 61 62 6c 65 | 5d 63 75 72 50 6f 73 20 |..[Table|]curPos |
|000045a0| 3d 20 31 0d 0a 09 09 7d | 0d 0a 09 7d 0d 0a 09 65 |= 1....}|...}...e|
|000045b0| 6c 73 65 0d 0a 20 7b 0d | 0a 20 20 5b 54 61 62 6c |lse.. {.|. [Tabl|
|000045c0| 65 5d 63 75 72 50 6f 73 | 20 2d 3d 20 5b 54 61 62 |e]curPos| -= [Tab|
|000045d0| 6c 65 5d 70 61 67 65 53 | 69 7a 65 2a 32 0d 0a 09 |le]pageS|ize*2...|
|000045e0| 20 69 66 20 28 5b 54 61 | 62 6c 65 5d 63 75 72 50 | if ([Ta|ble]curP|
|000045f0| 6f 73 20 3c 3d 20 30 29 | 0d 0a 09 20 7b 0d 0a 09 |os <= 0)|... {...|
|00004600| 09 20 5b 54 61 62 6c 65 | 5d 63 75 72 50 6f 73 20 |. [Table|]curPos |
|00004610| 3d 20 31 0d 0a 09 20 7d | 0d 0a 20 7d 0d 0a 7d 0d |= 1... }|.. }..}.|
|00004620| 0a 65 6c 73 65 20 69 66 | 20 28 5b 54 61 62 6c 65 |.else if| ([Table|
|00004630| 5d 5f 41 63 74 69 6f 6e | 20 3d 3d 20 22 46 6f 72 |]_Action| == "For|
|00004640| 77 61 72 64 22 29 0d 0a | 7b 09 0d 0a 20 69 66 20 |ward")..|{... if |
|00004650| 28 53 74 72 69 6e 67 28 | 5b 54 61 62 6c 65 5d 63 |(String(|[Table]c|
|00004660| 75 72 50 6f 73 29 20 3d | 3d 20 22 4e 61 4e 22 20 |urPos) =|= "NaN" |
|00004670| 7c 7c 20 28 5b 54 61 62 | 6c 65 5d 63 75 72 50 6f ||| ([Tab|le]curPo|
|00004680| 73 20 3e 20 5b 54 61 62 | 6c 65 5d 72 65 63 43 6f |s > [Tab|le]recCo|
|00004690| 75 6e 74 29 29 0d 0a 09 | 7b 0d 0a 09 09 5b 54 61 |unt))...|{....[Ta|
|000046a0| 62 6c 65 5d 63 75 72 50 | 6f 73 20 3d 20 5b 54 61 |ble]curP|os = [Ta|
|000046b0| 62 6c 65 5d 72 65 63 43 | 6f 75 6e 74 20 2d 20 5b |ble]recC|ount - [|
|000046c0| 54 61 62 6c 65 5d 53 74 | 61 74 65 20 2b 20 31 0d |Table]St|ate + 1.|
|000046d0| 0a 09 09 69 66 20 28 5b | 54 61 62 6c 65 5d 63 75 |...if ([|Table]cu|
|000046e0| 72 50 6f 73 20 3c 3d 20 | 30 29 0d 0a 09 09 7b 0d |rPos <= |0)....{.|
|000046f0| 0a 09 09 09 5b 54 61 62 | 6c 65 5d 63 75 72 50 6f |....[Tab|le]curPo|
|00004700| 73 20 3d 20 31 0d 0a 09 | 09 7d 0d 0a 09 7d 0d 0a |s = 1...|.}...}..|
|00004710| 7d 0d 0a 5b 54 61 62 6c | 65 5d 65 6e 64 52 65 63 |}..[Tabl|e]endRec|
|00004720| 20 3d 20 5b 54 61 62 6c | 65 5d 63 75 72 50 6f 73 | = [Tabl|e]curPos|
|00004730| 20 2b 20 5b 54 61 62 6c | 65 5d 70 61 67 65 53 69 | + [Tabl|e]pageSi|
|00004740| 7a 65 20 2d 20 31 0d 0a | 69 66 20 28 5b 54 61 62 |ze - 1..|if ([Tab|
|00004750| 6c 65 5d 65 6e 64 52 65 | 63 20 3e 20 5b 54 61 62 |le]endRe|c > [Tab|
|00004760| 6c 65 5d 72 65 63 43 6f | 75 6e 74 29 0d 0a 7b 0d |le]recCo|unt)..{.|
|00004770| 0a 20 20 20 20 5b 54 61 | 62 6c 65 5d 65 6e 64 52 |. [Ta|ble]endR|
|00004780| 65 63 20 3d 20 5b 54 61 | 62 6c 65 5d 72 65 63 43 |ec = [Ta|ble]recC|
|00004790| 6f 75 6e 74 0d 0a 7d 01 | 00 00 00 ff f8 04 27 20 |ount..}.|......' |
|000047a0| 54 68 65 20 66 6f 6c 6c | 6f 77 69 6e 67 20 63 6f |The foll|owing co|
|000047b0| 64 65 20 63 61 6c 63 75 | 6c 61 74 65 73 20 74 68 |de calcu|lates th|
|000047c0| 65 20 74 6f 70 20 61 6e | 64 20 62 6f 74 74 6f 6d |e top an|d bottom|
|000047d0| 20 0d 0a 27 20 72 65 63 | 6f 72 64 73 20 64 69 73 | ..' rec|ords dis|
|000047e0| 70 6c 61 79 65 64 20 69 | 6e 20 74 68 65 20 74 61 |played i|n the ta|
|000047f0| 62 6c 65 20 73 6f 20 69 | 74 20 63 61 6e 0d 0a 27 |ble so i|t can..'|
|00004800| 20 62 65 20 64 69 73 70 | 6c 61 79 65 64 20 69 6e | be disp|layed in|
|00004810| 20 61 20 74 65 78 74 20 | 62 6f 78 2e 0d 0a 0d 0a | a text |box.....|
|00004820| 5b 54 61 62 6c 65 5d 53 | 74 61 74 65 20 3d 20 52 |[Table]S|tate = R|
|00004830| 65 71 75 65 73 74 28 22 | 5b 54 61 62 6c 65 5d 5f |equest("|[Table]_|
|00004840| 53 74 61 74 65 22 29 20 | 26 20 22 22 0d 0a 5b 54 |State") |& ""..[T|
|00004850| 61 62 6c 65 5d 63 75 72 | 50 6f 73 20 3d 20 5b 52 |able]cur|Pos = [R|
|00004860| 65 63 6f 72 64 73 65 74 | 5d 2e 47 65 74 41 62 73 |ecordset|].GetAbs|
|00004870| 50 6f 73 28 29 0d 0a 5b | 54 61 62 6c 65 5d 70 61 |Pos()..[|Table]pa|
|00004880| 67 65 53 69 7a 65 20 3d | 20 5b 50 61 67 65 53 69 |geSize =| [PageSi|
|00004890| 7a 65 5d 0d 0a 5b 54 61 | 62 6c 65 5d 72 65 63 43 |ze]..[Ta|ble]recC|
|000048a0| 6f 75 6e 74 20 3d 20 5b | 52 65 63 6f 72 64 73 65 |ount = [|Recordse|
|000048b0| 74 5d 2e 52 53 2e 52 65 | 63 6f 72 64 43 6f 75 6e |t].RS.Re|cordCoun|
|000048c0| 74 0d 0a 0d 0a 69 66 20 | 5b 54 61 62 6c 65 5d 5f |t....if |[Table]_|
|000048d0| 41 63 74 69 6f 6e 20 3d | 20 22 42 61 63 6b 77 61 |Action =| "Backwa|
|000048e0| 72 64 22 20 74 68 65 6e | 0d 0a 0d 0a 09 69 66 20 |rd" then|.....if |
|000048f0| 4e 6f 74 20 49 73 4e 75 | 6d 65 72 69 63 28 5b 54 |Not IsNu|meric([T|
|00004900| 61 62 6c 65 5d 63 75 72 | 50 6f 73 29 20 74 68 65 |able]cur|Pos) the|
|00004910| 6e 09 0d 0a 09 09 5b 54 | 61 62 6c 65 5d 63 75 72 |n.....[T|able]cur|
|00004920| 50 6f 73 20 3d 20 5b 54 | 61 62 6c 65 5d 72 65 63 |Pos = [T|able]rec|
|00004930| 43 6f 75 6e 74 20 2d 20 | 5b 54 61 62 6c 65 5d 70 |Count - |[Table]p|
|00004940| 61 67 65 53 69 7a 65 20 | 2d 20 5b 54 61 62 6c 65 |ageSize |- [Table|
|00004950| 5d 53 74 61 74 65 20 2b | 20 31 0d 0a 09 09 69 66 |]State +| 1....if|
|00004960| 20 5b 54 61 62 6c 65 5d | 63 75 72 50 6f 73 20 3c | [Table]|curPos <|
|00004970| 3d 20 30 20 74 68 65 6e | 09 09 0d 0a 09 09 09 5b |= 0 then|.......[|
|00004980| 54 61 62 6c 65 5d 63 75 | 72 50 6f 73 20 3d 20 31 |Table]cu|rPos = 1|
|00004990| 0d 0a 09 09 65 6e 64 20 | 69 66 09 0d 0a 09 65 6c |....end |if....el|
|000049a0| 73 65 20 0d 0a 09 09 5b | 54 61 62 6c 65 5d 63 75 |se ....[|Table]cu|
|000049b0| 72 50 6f 73 20 3d 20 5b | 54 61 62 6c 65 5d 63 75 |rPos = [|Table]cu|
|000049c0| 72 50 6f 73 20 2d 20 5b | 54 61 62 6c 65 5d 70 61 |rPos - [|Table]pa|
|000049d0| 67 65 53 69 7a 65 2a 32 | 0d 0a 09 09 69 66 20 5b |geSize*2|....if [|
|000049e0| 54 61 62 6c 65 5d 63 75 | 72 50 6f 73 20 3c 3d 20 |Table]cu|rPos <= |
|000049f0| 30 20 74 68 65 6e 0d 0a | 09 09 09 5b 54 61 62 6c |0 then..|...[Tabl|
|00004a00| 65 5d 63 75 72 50 6f 73 | 20 3d 20 31 0d 0a 09 09 |e]curPos| = 1....|
|00004a10| 65 6e 64 20 69 66 0d 0a | 09 65 6e 64 20 69 66 0d |end if..|.end if.|
|00004a20| 0a 0d 0a 65 6c 73 65 69 | 66 20 5b 54 61 62 6c 65 |...elsei|f [Table|
|00004a30| 5d 5f 41 63 74 69 6f 6e | 20 3d 20 22 46 6f 72 77 |]_Action| = "Forw|
|00004a40| 61 72 64 22 20 74 68 65 | 6e 0d 0a 09 0d 0a 09 69 |ard" the|n......i|
|00004a50| 66 20 4e 6f 74 20 49 73 | 4e 75 6d 65 72 69 63 28 |f Not Is|Numeric(|
|00004a60| 5b 54 61 62 6c 65 5d 63 | 75 72 50 6f 73 29 20 74 |[Table]c|urPos) t|
|00004a70| 68 65 6e 0d 0a 09 09 5b | 54 61 62 6c 65 5d 63 75 |hen....[|Table]cu|
|00004a80| 72 50 6f 73 20 3d 20 43 | 4c 6e 67 28 5b 54 61 62 |rPos = C|Lng([Tab|
|00004a90| 6c 65 5d 72 65 63 43 6f | 75 6e 74 29 20 2d 20 43 |le]recCo|unt) - C|
|00004aa0| 4c 6e 67 28 5b 54 61 62 | 6c 65 5d 53 74 61 74 65 |Lng([Tab|le]State|
|00004ab0| 29 20 2b 20 31 0d 0a 09 | 09 69 66 20 5b 54 61 62 |) + 1...|.if [Tab|
|00004ac0| 6c 65 5d 63 75 72 50 6f | 73 20 3c 3d 20 30 20 74 |le]curPo|s <= 0 t|
|00004ad0| 68 65 6e 09 09 0d 0a 09 | 09 09 5b 54 61 62 6c 65 |hen.....|..[Table|
|00004ae0| 5d 63 75 72 50 6f 73 20 | 3d 20 31 0d 0a 09 09 65 |]curPos |= 1....e|
|00004af0| 6e 64 20 69 66 0d 0a 09 | 65 6e 64 20 69 66 0d 0a |nd if...|end if..|
|00004b00| 65 6e 64 20 69 66 0d 0a | 0d 0a 0d 0a 27 20 57 65 |end if..|....' We|
|00004b10| 20 64 6f 6e 27 74 20 77 | 61 6e 74 20 61 20 74 79 | don't w|ant a ty|
|00004b20| 70 65 20 6d 69 73 6d 61 | 74 63 68 20 65 72 72 6f |pe misma|tch erro|
|00004b30| 72 0d 0a 69 66 20 4e 6f | 74 20 49 73 4e 75 6d 65 |r..if No|t IsNume|
|00004b40| 72 69 63 28 5b 54 61 62 | 6c 65 5d 63 75 72 50 6f |ric([Tab|le]curPo|
|00004b50| 73 29 20 74 68 65 6e 0d | 0a 20 20 20 20 5b 54 61 |s) then.|. [Ta|
|00004b60| 62 6c 65 5d 63 75 72 50 | 6f 73 20 3d 20 30 0d 0a |ble]curP|os = 0..|
|00004b70| 65 6e 64 20 69 66 0d 0a | 0d 0a 27 20 41 64 64 20 |end if..|..' Add |
|00004b80| 61 20 7a 65 72 6f 20 69 | 6e 20 74 68 65 20 66 72 |a zero i|n the fr|
|00004b90| 6f 6e 74 20 74 6f 20 65 | 6e 73 75 72 65 20 69 74 |ont to e|nsure it|
|00004ba0| 20 69 73 20 6e 6f 74 20 | 73 74 72 69 6e 67 20 63 | is not |string c|
|00004bb0| 6f 6e 63 61 74 2e 0d 0a | 27 52 65 73 70 6f 6e 73 |oncat...|'Respons|
|00004bc0| 65 2e 57 72 69 74 65 28 | 22 65 6e 64 52 65 63 20 |e.Write(|"endRec |
|00004bd0| 3d 20 22 20 26 20 5b 54 | 61 62 6c 65 5d 65 6e 64 |= " & [T|able]end|
|00004be0| 52 65 63 20 26 20 22 20 | 63 75 72 70 6f 73 20 3d |Rec & " |curpos =|
|00004bf0| 20 22 20 26 20 5b 54 61 | 62 6c 65 5d 63 75 72 50 | " & [Ta|ble]curP|
|00004c00| 6f 73 29 0d 0a 5b 54 61 | 62 6c 65 5d 65 6e 64 52 |os)..[Ta|ble]endR|
|00004c10| 65 63 20 3d 20 30 20 2b | 20 5b 54 61 62 6c 65 5d |ec = 0 +| [Table]|
|00004c20| 63 75 72 50 6f 73 20 2b | 20 5b 54 61 62 6c 65 5d |curPos +| [Table]|
|00004c30| 70 61 67 65 53 69 7a 65 | 20 2d 20 31 0d 0a 0d 0a |pageSize| - 1....|
|00004c40| 69 66 20 28 5b 54 61 62 | 6c 65 5d 65 6e 64 52 65 |if ([Tab|le]endRe|
|00004c50| 63 20 3e 20 5b 54 61 62 | 6c 65 5d 72 65 63 43 6f |c > [Tab|le]recCo|
|00004c60| 75 6e 74 29 20 74 68 65 | 6e 0d 0a 20 20 20 20 5b |unt) the|n.. [|
|00004c70| 54 61 62 6c 65 5d 65 6e | 64 52 65 63 20 3d 20 5b |Table]en|dRec = [|
|00004c80| 54 61 62 6c 65 5d 72 65 | 63 43 6f 75 6e 74 0d 0a |Table]re|cCount..|
|00004c90| 65 6e 64 20 69 66 04 00 | 3e 80 05 00 00 00 08 50 |end if..|>......P|
|00004ca0| 61 67 65 53 69 7a 65 02 | 00 00 00 03 00 0a 00 00 |ageSize.|........|
|00004cb0| 00 00 00 00 00 00 00 00 | 00 00 00 00 3e 80 05 00 |........|....>...|
|00004cc0| 00 00 10 54 6f 70 20 52 | 65 63 6f 72 64 20 54 6f |...Top R|ecord To|
|00004cd0| 6b 65 6e 00 00 00 00 08 | 00 06 00 00 00 54 00 4f |ken.....|.....T.O|
|00004ce0| 00 50 00 00 00 00 00 00 | 00 00 00 00 00 00 3e 80 |.P......|......>.|
|00004cf0| 05 00 00 00 13 42 6f 74 | 74 6f 6d 20 52 65 63 6f |.....Bot|tom Reco|
|00004d00| 72 64 20 54 6f 6b 65 6e | 00 00 00 00 08 00 06 00 |rd Token|........|
|00004d10| 00 00 42 00 4f 00 54 00 | 00 00 00 00 00 00 00 00 |..B.O.T.|........|
|00004d20| 00 00 00 3e 80 05 00 00 | 00 12 54 6f 74 61 6c 20 |...>....|..Total |
|00004d30| 52 65 63 6f 72 64 20 54 | 6f 6b 65 6e 00 00 00 00 |Record T|oken....|
|00004d40| 08 00 06 00 00 00 54 00 | 4f 00 54 00 00 00 00 00 |......T.|O.T.....|
|00004d50| 00 00 00 00 00 00 00 13 | 44 61 74 61 62 61 73 65 |........|Database|
|00004d60| 20 6e 61 76 69 67 61 74 | 69 6f 6e 01 00 0f 2a 65 | navigat|ion...*e|
|00004d70| 12 28 83 d2 11 80 52 00 | 10 4b d3 38 d1 00 00 00 |.(....R.|.K.8....|
|00004d80| 00 04 00 00 00 01 00 00 | 00 01 00 0b 80 04 00 00 |........|........|
|00004d90| 00 06 53 65 72 76 65 72 | 01 00 00 00 01 00 00 00 |..Server|........|
|00004da0| 39 5b 54 61 62 6c 65 5d | 63 75 72 50 6f 73 20 3d |9[Table]|curPos =|
|00004db0| 20 30 0d 0a 5b 54 61 62 | 6c 65 5d 72 65 63 43 6f | 0..[Tab|le]recCo|
|00004dc0| 75 6e 74 20 3d 20 30 0d | 0a 5b 54 61 62 6c 65 5d |unt = 0.|.[Table]|
|00004dd0| 65 6e 64 52 65 63 20 3d | 20 30 7e 40 8b ce e8 83 |endRec =| 0~@....|
|00004de0| d2 11 80 53 00 10 4b d3 | 38 d1 01 00 00 00 24 33 |...S..K.|8.....$3|
|00004df0| 37 37 41 43 34 33 30 2d | 36 32 31 31 2d 31 31 44 |77AC430-|6211-11D|
|00004e00| 32 2d 38 31 31 37 2d 30 | 30 36 30 30 38 43 38 36 |2-8117-0|06008C86|
|00004e10| 43 32 35 03 33 2e 30 ff | df 08 56 31 30 5f 33 30 |C25.3.0.|..V10_30|
|00004e20| 0d 0a 44 65 73 63 72 69 | 70 74 69 6f 6e 3a 0d 0a |..Descri|ption:..|
|00004e30| 54 68 69 73 20 33 2d 77 | 61 79 20 69 6e 74 65 72 |This 3-w|ay inter|
|00004e40| 61 63 74 69 6f 6e 20 62 | 65 74 77 65 65 6e 20 61 |action b|etween a|
|00004e50| 20 72 65 63 6f 72 64 73 | 65 74 2c 20 41 75 74 6f | records|et, Auto|
|00004e60| 54 61 62 6c 65 2c 20 61 | 6e 64 20 74 65 78 74 20 |Table, a|nd text |
|00004e70| 65 6c 65 6d 65 6e 74 20 | 72 65 70 6c 61 63 65 73 |element |replaces|
|00004e80| 20 74 6f 6b 65 6e 73 20 | 69 6e 20 61 20 74 65 78 | tokens |in a tex|
|00004e90| 74 20 65 6c 65 6d 65 6e | 74 20 77 69 74 68 20 74 |t elemen|t with t|
|00004ea0| 68 65 20 66 6f 6c 6c 6f | 77 69 6e 67 20 76 61 6c |he follo|wing val|
|00004eb0| 75 65 73 3a 20 0d 0a 20 | 20 20 20 74 68 65 20 6e |ues: .. | the n|
|00004ec0| 75 6d 62 65 72 20 6f 66 | 20 74 68 65 20 72 65 63 |umber of| the rec|
|00004ed0| 6f 72 64 20 64 69 73 70 | 6c 61 79 65 64 20 69 6e |ord disp|layed in|
|00004ee0| 20 74 68 65 20 66 69 72 | 73 74 20 6c 69 6e 65 20 | the fir|st line |
|00004ef0| 6f 66 20 74 68 65 20 74 | 61 62 6c 65 20 6f 6e 20 |of the t|able on |
|00004f00| 74 68 65 20 63 75 72 72 | 65 6e 74 20 20 20 20 20 |the curr|ent |
|00004f10| 0d 0a 20 20 20 20 70 61 | 67 65 3b 20 0d 0a 20 20 |.. pa|ge; .. |
|00004f20| 20 20 74 68 65 20 6e 75 | 6d 62 65 72 20 6f 66 20 | the nu|mber of |
|00004f30| 74 68 65 20 72 65 63 6f | 72 64 20 64 69 73 70 6c |the reco|rd displ|
|00004f40| 61 79 65 64 20 69 6e 20 | 74 68 65 20 6c 61 73 74 |ayed in |the last|
|00004f50| 20 6c 69 6e 65 20 6f 66 | 20 74 68 65 20 74 61 62 | line of| the tab|
|00004f60| 6c 65 20 6f 6e 20 74 68 | 69 73 20 70 61 67 65 3b |le on th|is page;|
|00004f70| 0d 0a 20 20 20 20 74 68 | 65 20 74 6f 74 61 6c 20 |.. th|e total |
|00004f80| 6e 75 6d 62 65 72 20 6f | 66 20 72 65 63 6f 72 64 |number o|f record|
|00004f90| 73 20 69 6e 20 74 68 65 | 20 52 65 63 6f 72 64 73 |s in the| Records|
|00004fa0| 65 74 0d 0a 0d 0a 59 6f | 75 20 6d 75 73 74 20 73 |et....Yo|u must s|
|00004fb0| 70 65 63 69 66 79 20 74 | 68 65 20 74 6f 6b 65 6e |pecify t|he token|
|00004fc0| 73 20 69 6e 20 74 68 65 | 20 74 65 78 74 20 65 6c |s in the| text el|
|00004fd0| 65 6d 65 6e 74 20 61 6e | 64 20 73 75 70 70 6c 79 |ement an|d supply|
|00004fe0| 20 74 68 65 73 65 20 76 | 61 6c 75 65 73 20 65 78 | these v|alues ex|
|00004ff0| 61 63 74 6c 79 20 28 63 | 61 73 65 20 73 65 6e 73 |actly (c|ase sens|
|00005000| 69 74 69 76 65 29 20 61 | 73 20 74 68 65 20 63 6f |itive) a|s the co|
|00005010| 72 72 65 73 70 6f 6e 64 | 69 6e 67 20 70 61 72 61 |rrespond|ing para|
|00005020| 6d 65 74 65 72 73 20 66 | 6f 72 20 74 68 65 20 54 |meters f|or the T|
|00005030| 6f 70 20 72 65 63 6f 72 | 64 2c 20 42 6f 74 74 6f |op recor|d, Botto|
|00005040| 6d 20 72 65 63 6f 72 64 | 20 61 6e 64 20 54 6f 74 |m record| and Tot|
|00005050| 61 6c 20 72 65 63 6f 72 | 64 20 74 6f 6b 65 6e 73 |al recor|d tokens|
|00005060| 2e 0d 0a 0d 0a 50 61 72 | 61 6d 65 74 65 72 73 3a |.....Par|ameters:|
|00005070| 0d 0a 50 61 67 65 53 69 | 7a 65 20 2d 20 74 68 65 |..PageSi|ze - the|
|00005080| 20 6d 61 78 69 6d 75 6d | 20 6e 75 6d 62 65 72 20 | maximum| number |
|00005090| 6f 66 20 72 65 63 6f 72 | 64 73 20 74 6f 20 62 65 |of recor|ds to be|
|000050a0| 20 64 69 73 70 6c 61 79 | 65 64 20 69 6e 20 74 68 | display|ed in th|
|000050b0| 65 20 74 61 62 6c 65 20 | 61 74 20 6f 6e 65 20 20 |e table |at one |
|000050c0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|000050d0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|000050e0| 20 20 20 20 74 69 6d 65 | 20 28 53 68 6f 75 6c 64 | time| (Should|
|000050f0| 20 62 65 20 74 68 65 20 | 73 61 6d 65 20 61 73 20 | be the |same as |
|00005100| 74 68 65 20 50 61 67 65 | 20 53 69 7a 65 20 61 74 |the Page| Size at|
|00005110| 74 72 69 62 75 74 65 20 | 6f 66 20 74 68 65 20 41 |tribute |of the A|
|00005120| 75 74 6f 54 61 62 6c 65 | 29 0d 0a 54 6f 70 20 52 |utoTable|)..Top R|
|00005130| 65 63 6f 72 64 20 54 6f | 6b 65 6e 20 2d 20 54 6f |ecord To|ken - To|
|00005140| 6b 65 6e 20 75 73 65 64 | 20 69 6e 20 74 68 65 20 |ken used| in the |
|00005150| 74 65 78 74 20 65 6c 65 | 6d 65 6e 74 20 66 6f 72 |text ele|ment for|
|00005160| 20 74 68 65 20 74 6f 70 | 20 72 65 63 6f 72 64 0d | the top| record.|
|00005170| 0a 42 6f 74 74 6f 6d 20 | 52 65 63 6f 72 64 20 54 |.Bottom |Record T|
|00005180| 6f 6b 65 6e 20 2d 20 54 | 6f 6b 65 6e 20 75 73 65 |oken - T|oken use|
|00005190| 64 20 69 6e 20 74 68 65 | 20 74 65 78 74 20 65 6c |d in the| text el|
|000051a0| 65 6d 65 6e 74 20 66 6f | 72 20 74 68 65 20 62 6f |ement fo|r the bo|
|000051b0| 74 74 6f 6d 20 72 65 63 | 6f 72 64 0d 0a 54 6f 74 |ttom rec|ord..Tot|
|000051c0| 61 6c 20 52 65 63 6f 72 | 64 20 54 6f 6b 65 6e 20 |al Recor|d Token |
|000051d0| 2d 20 54 6f 6b 65 6e 20 | 75 73 65 64 20 69 6e 20 |- Token |used in |
|000051e0| 74 68 65 20 74 65 78 74 | 20 65 6c 65 6d 65 6e 74 |the text| element|
|000051f0| 20 66 6f 72 20 74 68 65 | 20 74 6f 74 61 6c 20 72 | for the| total r|
|00005200| 65 63 6f 72 64 73 0d 0a | 0d 0a 54 79 70 69 63 61 |ecords..|..Typica|
|00005210| 6c 20 50 61 72 74 69 63 | 69 70 61 6e 74 73 3a 0d |l Partic|ipants:.|
|00005220| 0a 5b 52 65 63 6f 72 64 | 73 65 74 5d 20 2d 20 61 |.[Record|set] - a|
|00005230| 20 52 65 63 6f 72 64 73 | 65 74 0d 0a 5b 54 65 78 | Records|et..[Tex|
|00005240| 74 20 45 6c 65 6d 65 6e | 74 5d 20 2d 20 74 68 65 |t Elemen|t] - the|
|00005250| 20 74 65 78 74 20 65 6c | 65 6d 65 6e 74 20 74 68 | text el|ement th|
|00005260| 61 74 20 68 61 73 20 6f | 6e 65 20 6f 72 20 6d 6f |at has o|ne or mo|
|00005270| 72 65 20 6f 66 20 74 68 | 65 20 61 62 6f 76 65 20 |re of th|e above |
|00005280| 74 6f 6b 65 6e 73 20 69 | 6e 20 69 74 2e 0d 0a 5b |tokens i|n it...[|
|00005290| 54 61 62 6c 65 5d 20 2d | 20 61 6e 20 41 75 74 6f |Table] -| an Auto|
|000052a0| 54 61 62 6c 65 20 74 68 | 61 74 20 69 73 20 70 6f |Table th|at is po|
|000052b0| 70 75 6c 61 74 65 64 20 | 62 79 20 74 68 65 20 61 |pulated |by the a|
|000052c0| 62 6f 76 65 20 52 65 63 | 6f 72 64 73 65 74 0d 0a |bove Rec|ordset..|
|000052d0| 0d 0a 45 78 61 6d 70 6c | 65 3a 20 53 75 70 70 6f |..Exampl|e: Suppo|
|000052e0| 73 65 20 74 68 65 20 52 | 65 73 75 6c 74 20 4c 69 |se the R|esult Li|
|000052f0| 73 74 20 70 61 67 65 20 | 6f 66 20 79 6f 75 72 20 |st page |of your |
|00005300| 44 61 74 61 46 6f 72 6d | 20 61 70 70 20 68 61 73 |DataForm| app has|
|00005310| 20 61 6e 20 41 75 74 6f | 54 61 62 6c 65 20 77 69 | an Auto|Table wi|
|00005320| 74 68 20 61 20 70 61 67 | 65 20 73 69 7a 65 20 6f |th a pag|e size o|
|00005330| 66 20 31 30 2e 20 20 59 | 6f 75 20 63 6f 75 6c 64 |f 10. Y|ou could|
|00005340| 20 68 61 76 65 20 61 20 | 74 65 78 74 20 65 6c 65 | have a |text ele|
|00005350| 6d 65 6e 74 20 6f 6e 20 | 74 68 69 73 20 70 61 67 |ment on |this pag|
|00005360| 65 20 77 69 74 68 20 74 | 68 65 20 76 61 6c 75 65 |e with t|he value|
|00005370| 20 22 52 65 63 6f 72 64 | 73 20 54 4f 50 20 74 68 | "Record|s TOP th|
|00005380| 72 6f 75 67 68 20 42 4f | 54 20 6f 66 20 54 4f 54 |rough BO|T of TOT|
|00005390| 22 20 69 6e 20 69 74 2e | 20 20 41 66 74 65 72 20 |" in it.| After |
|000053a0| 61 70 70 6c 79 69 6e 67 | 20 74 68 69 73 20 63 6f |applying| this co|
|000053b0| 6e 74 72 61 63 74 20 74 | 6f 20 74 68 65 20 74 65 |ntract t|o the te|
|000053c0| 78 74 20 65 6c 65 6d 65 | 6e 74 2c 20 74 68 65 20 |xt eleme|nt, the |
|000053d0| 41 75 74 6f 54 61 62 6c | 65 2c 20 61 6e 64 20 74 |AutoTabl|e, and t|
|000053e0| 68 65 20 52 65 63 6f 72 | 64 73 65 74 20 79 6f 75 |he Recor|dset you|
|000053f0| 20 77 69 6c 6c 20 73 65 | 65 20 74 68 65 20 66 6f | will se|e the fo|
|00005400| 6c 6c 6f 77 69 6e 67 20 | 77 68 65 6e 20 62 72 6f |llowing |when bro|
|00005410| 77 73 69 6e 67 20 74 68 | 69 73 20 70 61 67 65 2e |wsing th|is page.|
|00005420| 20 20 54 68 65 20 66 69 | 72 73 74 20 74 69 6d 65 | The fi|rst time|
|00005430| 20 79 6f 75 20 67 6f 20 | 74 6f 20 74 68 65 20 70 | you go |to the p|
|00005440| 61 67 65 2c 20 74 68 65 | 20 74 65 78 74 20 65 6c |age, the| text el|
|00005450| 65 6d 65 6e 74 20 77 69 | 6c 6c 20 73 61 79 20 22 |ement wi|ll say "|
|00005460| 52 65 63 6f 72 64 73 20 | 31 20 74 68 72 6f 75 67 |Records |1 throug|
|00005470| 68 20 31 30 20 6f 66 20 | 31 30 32 22 20 69 66 20 |h 10 of |102" if |
|00005480| 74 68 65 72 65 20 61 72 | 65 20 31 30 32 20 72 65 |there ar|e 102 re|
|00005490| 63 6f 72 64 73 20 69 6e | 20 74 68 65 20 52 65 63 |cords in| the Rec|
|000054a0| 6f 72 64 73 65 74 2e 20 | 20 41 6e 64 20 69 66 20 |ordset. | And if |
|000054b0| 79 6f 75 20 63 6c 69 63 | 6b 20 74 68 65 20 4d 6f |you clic|k the Mo|
|000054c0| 72 65 20 62 75 74 74 6f | 6e 2c 20 74 68 65 20 74 |re butto|n, the t|
|000054d0| 65 78 74 20 65 6c 65 6d | 65 6e 74 20 77 69 6c 6c |ext elem|ent will|
|000054e0| 20 73 61 79 20 22 52 65 | 63 6f 72 64 73 20 31 31 | say "Re|cords 11|
|000054f0| 20 74 68 72 6f 75 67 68 | 20 32 30 20 6f 66 20 31 | through| 20 of 1|
|00005500| 30 32 22 2e 20 20 49 66 | 20 74 68 65 72 65 20 61 |02". If| there a|
|00005510| 72 65 20 6e 6f 20 72 65 | 63 6f 72 64 73 20 74 6f |re no re|cords to|
|00005520| 20 62 65 20 64 69 73 70 | 6c 61 79 65 64 20 61 74 | be disp|layed at|
|00005530| 20 61 6c 6c 2c 20 74 68 | 65 20 74 65 78 74 20 65 | all, th|e text e|
|00005540| 6c 65 6d 65 6e 74 20 77 | 69 6c 6c 20 62 65 20 62 |lement w|ill be b|
|00005550| 6c 61 6e 6b 65 64 20 6f | 75 74 20 74 6f 20 61 76 |lanked o|ut to av|
|00005560| 6f 69 64 20 73 61 79 69 | 6e 67 20 73 6f 6d 65 74 |oid sayi|ng somet|
|00005570| 68 69 6e 67 20 6c 69 6b | 65 20 22 52 65 63 6f 72 |hing lik|e "Recor|
|00005580| 64 73 20 4e 61 4e 20 74 | 68 72 6f 75 67 68 20 4e |ds NaN t|hrough N|
|00005590| 61 4e 20 6f 66 20 30 22 | 0d 0a 0d 0a 4e 6f 74 65 |aN of 0"|....Note|
|000055a0| 3a 20 69 74 20 69 73 20 | 69 6d 70 6f 72 74 61 6e |: it is |importan|
|000055b0| 74 20 74 68 61 74 20 74 | 68 69 73 20 63 6f 6e 74 |t that t|his cont|
|000055c0| 72 61 63 74 20 62 65 20 | 65 78 65 63 75 74 65 64 |ract be |executed|
|000055d0| 20 6f 6e 20 74 68 65 20 | 52 65 63 6f 72 64 73 65 | on the |Recordse|
|000055e0| 74 20 41 46 54 45 52 20 | 61 6e 79 20 66 69 6c 74 |t AFTER |any filt|
|000055f0| 65 72 73 20 68 61 76 65 | 20 62 65 65 6e 20 61 70 |ers have| been ap|
|00005600| 70 6c 69 65 64 20 74 6f | 20 74 68 65 20 52 65 63 |plied to| the Rec|
|00005610| 6f 72 64 73 65 74 2e 20 | 20 59 6f 75 20 63 61 6e |ordset. | You can|
|00005620| 20 64 65 63 69 64 65 20 | 74 68 65 20 6f 72 64 65 | decide |the orde|
|00005630| 72 20 69 6e 20 77 68 69 | 63 68 20 74 68 65 20 63 |r in whi|ch the c|
|00005640| 6f 6e 74 72 61 63 74 73 | 20 61 72 65 20 65 78 65 |ontracts| are exe|
|00005650| 63 75 74 65 64 20 62 79 | 20 72 69 67 68 74 2d 63 |cuted by| right-c|
|00005660| 6c 69 63 6b 69 6e 67 20 | 6f 6e 20 74 68 65 20 52 |licking |on the R|
|00005670| 65 63 6f 72 64 73 65 74 | 20 69 63 6f 6e 20 61 6e |ecordset| icon an|
|00005680| 64 20 73 65 6c 65 63 74 | 69 6e 67 0d 0a 22 41 73 |d select|ing.."As|
|00005690| 73 69 67 6e 65 64 20 49 | 6e 74 65 72 61 63 74 69 |signed I|nteracti|
|000056a0| 6f 6e 73 20 28 6f 72 64 | 65 72 65 64 29 22 20 61 |ons (ord|ered)" a|
|000056b0| 6e 64 20 74 68 65 6e 20 | 64 72 61 67 67 69 6e 67 |nd then |dragging|
|000056c0| 20 74 68 65 20 69 6e 74 | 65 72 61 63 74 69 6f 6e | the int|eraction|
|000056d0| 73 20 74 6f 20 74 68 65 | 20 6f 72 64 65 72 20 79 |s to the| order y|
|000056e0| 6f 75 20 77 61 6e 74 20 | 74 68 65 6d 20 74 6f 20 |ou want |them to |
|000056f0| 61 70 70 65 61 72 2e 0d | 0a 05 80 12 00 00 00 4a |appear..|.......J|
|00005700| 52 65 70 6c 61 63 65 20 | 54 6f 6b 65 6e 73 20 69 |Replace |Tokens i|
|00005710| 6e 20 5b 54 65 78 74 20 | 45 6c 65 6d 65 6e 74 5d |n [Text |Element]|
|00005720| 20 77 69 74 68 20 63 75 | 72 72 65 6e 74 20 72 65 | with cu|rrent re|
|00005730| 63 6f 72 64 20 6e 75 6d | 62 65 72 20 6f 66 20 5b |cord num|ber of [|
|00005740| 52 65 63 6f 72 64 73 65 | 74 5d 00 00 00 00 00 02 |Recordse|t]......|
|00005750| 00 07 80 01 00 00 00 0c | 54 65 78 74 20 45 6c 65 |........|Text Ele|
|00005760| 6d 65 6e 74 02 00 09 80 | 03 00 00 00 02 00 00 00 |ment....|........|
|00005770| 09 74 65 78 74 53 74 79 | 6c 65 09 80 03 00 00 00 |.textSty|le......|
|00005780| 00 00 00 00 0c 53 65 72 | 76 65 72 28 68 74 6d 6c |.....Ser|ver(html|
|00005790| 29 01 00 0b 80 04 00 00 | 00 0c 53 65 72 76 65 72 |).......|..Server|
|000057a0| 28 68 74 6d 6c 29 02 00 | 00 00 00 00 00 00 ff cd |(html)..|........|
|000057b0| 01 2f 2f 20 54 68 65 20 | 76 61 72 69 61 62 6c 65 |.// The |variable|
|000057c0| 73 20 61 72 65 20 63 61 | 6c 63 75 6c 61 74 65 64 |s are ca|lculated|
|000057d0| 20 69 6e 20 74 68 65 20 | 53 65 72 76 65 72 0d 0a | in the |Server..|
|000057e0| 2f 2f 20 65 76 65 6e 74 | 20 6f 66 20 74 68 65 20 |// event| of the |
|000057f0| 72 65 63 6f 72 64 73 65 | 74 2e 0d 0a 0d 0a 69 66 |recordse|t.....if|
|00005800| 20 28 69 73 4e 61 4e 28 | 5b 52 65 63 6f 72 64 73 | (isNaN(|[Records|
|00005810| 65 74 5d 63 75 72 50 6f | 73 29 29 0d 0a 7b 0d 0a |et]curPo|s))..{..|
|00005820| 20 20 20 20 2f 2f 20 54 | 68 65 79 20 68 61 76 65 | // T|hey have|
|00005830| 20 68 69 74 20 70 72 65 | 76 20 77 68 69 6c 65 20 | hit pre|v while |
|00005840| 6f 6e 20 74 68 65 20 66 | 69 72 73 74 20 72 65 63 |on the f|irst rec|
|00005850| 20 6f 72 0d 0a 20 20 20 | 20 2f 2f 20 74 68 65 79 | or.. | // they|
|00005860| 20 68 61 76 65 20 68 69 | 74 20 6e 65 78 74 20 77 | have hi|t next w|
|00005870| 68 69 6c 65 20 6f 6e 20 | 74 68 65 20 6c 61 73 74 |hile on |the last|
|00005880| 20 72 65 63 0d 0a 20 20 | 20 20 2f 2f 20 73 6f 20 | rec.. | // so |
|00005890| 77 65 20 64 6f 6e 27 74 | 20 77 61 6e 74 20 74 6f |we don't| want to|
|000058a0| 20 64 69 73 70 61 6c 79 | 20 61 6e 79 74 68 69 6e | dispaly| anythin|
|000058b0| 67 2e 0d 0a 0d 0a 20 20 | 20 20 68 74 6d 6c 20 3d |g..... | html =|
|000058c0| 20 22 22 0d 0a 7d 0d 0a | 65 6c 73 65 0d 0a 7b 0d | ""..}..|else..{.|
|000058d0| 0a 20 20 20 20 68 74 6d | 6c 20 3d 20 73 75 62 41 |. htm|l = subA|
|000058e0| 77 69 74 68 42 69 6e 43 | 28 5b 52 65 63 6f 72 64 |withBinC|([Record|
|000058f0| 20 4e 75 6d 62 65 72 20 | 54 6f 6b 65 6e 5d 2c 20 | Number |Token], |
|00005900| 5b 52 65 63 6f 72 64 73 | 65 74 5d 63 75 72 50 6f |[Records|et]curPo|
|00005910| 73 2c 20 68 74 6d 6c 29 | 0d 0a 20 20 20 20 68 74 |s, html)|.. ht|
|00005920| 6d 6c 20 3d 20 73 75 62 | 41 77 69 74 68 42 69 6e |ml = sub|AwithBin|
|00005930| 43 28 5b 54 6f 74 61 6c | 20 52 65 63 6f 72 64 73 |C([Total| Records|
|00005940| 20 54 6f 6b 65 6e 5d 2c | 20 5b 52 65 63 6f 72 64 | Token],| [Record|
|00005950| 73 65 74 5d 72 65 63 43 | 6f 75 6e 74 2c 20 68 74 |set]recC|ount, ht|
|00005960| 6d 6c 29 0d 0a 7d 0d 0a | 0d 0a 52 65 73 70 6f 6e |ml)..}..|..Respon|
|00005970| 73 65 2e 57 72 69 74 65 | 28 68 74 6d 6c 29 01 00 |se.Write|(html)..|
|00005980| 00 00 ff 53 01 27 20 54 | 68 65 20 76 61 72 69 61 |...S.' T|he varia|
|00005990| 62 6c 65 73 20 61 72 65 | 20 63 61 6c 63 75 6c 61 |bles are| calcula|
|000059a0| 74 65 64 20 69 6e 20 74 | 68 65 20 53 65 72 76 65 |ted in t|he Serve|
|000059b0| 72 0d 0a 27 20 65 76 65 | 6e 74 20 6f 66 20 74 68 |r..' eve|nt of th|
|000059c0| 65 20 72 65 63 6f 72 64 | 73 65 74 2e 0d 0a 0d 0a |e record|set.....|
|000059d0| 69 66 20 4e 6f 74 20 49 | 73 4e 75 6d 65 72 69 63 |if Not I|sNumeric|
|000059e0| 28 5b 52 65 63 6f 72 64 | 73 65 74 5d 63 75 72 50 |([Record|set]curP|
|000059f0| 6f 73 29 20 74 68 65 6e | 0d 0a 20 20 20 20 68 74 |os) then|.. ht|
|00005a00| 6d 6c 20 20 3d 20 22 22 | 0d 0a 65 6c 73 65 0d 0a |ml = ""|..else..|
|00005a10| 20 20 20 20 68 74 6d 6c | 20 3d 20 73 75 62 41 77 | html| = subAw|
|00005a20| 69 74 68 42 69 6e 43 28 | 5b 52 65 63 6f 72 64 20 |ithBinC(|[Record |
|00005a30| 4e 75 6d 62 65 72 20 54 | 6f 6b 65 6e 5d 2c 20 74 |Number T|oken], t|
|00005a40| 72 69 6d 28 63 73 74 72 | 28 5b 52 65 63 6f 72 64 |rim(cstr|([Record|
|00005a50| 73 65 74 5d 63 75 72 50 | 6f 73 29 29 2c 20 68 74 |set]curP|os)), ht|
|00005a60| 6d 6c 29 0d 0a 20 20 20 | 20 68 74 6d 6c 20 3d 20 |ml).. | html = |
|00005a70| 73 75 62 41 77 69 74 68 | 42 69 6e 43 28 5b 54 6f |subAwith|BinC([To|
|00005a80| 74 61 6c 20 52 65 63 6f | 72 64 73 20 54 6f 6b 65 |tal Reco|rds Toke|
|00005a90| 6e 5d 2c 20 74 72 69 6d | 28 63 73 74 72 28 5b 52 |n], trim|(cstr([R|
|00005aa0| 65 63 6f 72 64 73 65 74 | 5d 72 65 63 43 6f 75 6e |ecordset|]recCoun|
|00005ab0| 74 29 29 2c 20 68 74 6d | 6c 29 0d 0a 65 6e 64 20 |t)), htm|l)..end |
|00005ac0| 69 66 0d 0a 52 65 73 70 | 6f 6e 73 65 2e 57 72 69 |if..Resp|onse.Wri|
|00005ad0| 74 65 28 68 74 6d 6c 29 | 07 80 01 00 00 00 09 52 |te(html)|.......R|
|00005ae0| 65 63 6f 72 64 73 65 74 | 03 00 09 80 03 00 00 00 |ecordset|........|
|00005af0| 00 00 00 00 0c 42 65 66 | 6f 72 65 4f 70 65 6e 28 |.....Bef|oreOpen(|
|00005b00| 29 09 80 03 00 00 00 00 | 00 00 00 08 53 65 72 76 |).......|....Serv|
|00005b10| 65 72 28 29 09 80 03 00 | 00 00 01 00 00 00 0b 4d |er()....|.......M|
|00005b20| 6f 76 65 46 69 72 73 74 | 28 29 01 00 0b 80 04 00 |oveFirst|()......|
|00005b30| 00 00 08 53 65 72 76 65 | 72 28 29 02 00 00 00 00 |...Serve|r().....|
|00005b40| 00 00 00 a3 5b 52 65 63 | 6f 72 64 73 65 74 5d 63 |....[Rec|ordset]c|
|00005b50| 75 72 50 6f 73 20 3d 20 | 5b 52 65 63 6f 72 64 73 |urPos = |[Records|
|00005b60| 65 74 5d 2e 47 65 74 41 | 62 73 50 6f 73 28 29 0d |et].GetA|bsPos().|
|00005b70| 0a 5b 52 65 63 6f 72 64 | 73 65 74 5d 72 65 63 43 |.[Record|set]recC|
|00005b80| 6f 75 6e 74 20 3d 20 5b | 52 65 63 6f 72 64 73 65 |ount = [|Recordse|
|00005b90| 74 5d 2e 52 53 2e 52 65 | 63 6f 72 64 43 6f 75 6e |t].RS.Re|cordCoun|
|00005ba0| 74 0d 0a 0d 0a 69 66 20 | 28 69 73 4e 61 4e 28 5b |t....if |(isNaN([|
|00005bb0| 52 65 63 6f 72 64 73 65 | 74 5d 63 75 72 50 6f 73 |Recordse|t]curPos|
|00005bc0| 29 29 0d 0a 7b 0d 0a 20 | 20 20 20 5b 52 65 63 6f |))..{.. | [Reco|
|00005bd0| 72 64 73 65 74 5d 63 75 | 72 50 6f 73 20 3d 20 22 |rdset]cu|rPos = "|
|00005be0| 45 4f 46 22 0d 0a 7d 01 | 00 00 00 b3 5b 52 65 63 |EOF"..}.|....[Rec|
|00005bf0| 6f 72 64 73 65 74 5d 63 | 75 72 50 6f 73 20 3d 20 |ordset]c|urPos = |
|00005c00| 5b 52 65 63 6f 72 64 73 | 65 74 5d 2e 47 65 74 41 |[Records|et].GetA|
|00005c10| 62 73 50 6f 73 28 29 0d | 0a 5b 52 65 63 6f 72 64 |bsPos().|.[Record|
|00005c20| 73 65 74 5d 72 65 63 43 | 6f 75 6e 74 20 3d 20 5b |set]recC|ount = [|
|00005c30| 52 65 63 6f 72 64 73 65 | 74 5d 2e 52 53 2e 52 65 |Recordse|t].RS.Re|
|00005c40| 63 6f 72 64 43 6f 75 6e | 74 0d 0a 0d 0a 69 66 20 |cordCoun|t....if |
|00005c50| 4e 6f 74 20 49 73 4e 75 | 6d 65 72 69 63 28 5b 52 |Not IsNu|meric([R|
|00005c60| 65 63 6f 72 64 73 65 74 | 5d 63 75 72 50 6f 73 29 |ecordset|]curPos)|
|00005c70| 20 74 68 65 6e 09 09 09 | 0d 0a 20 20 20 20 5b 52 | then...|.. [R|
|00005c80| 65 63 6f 72 64 73 65 74 | 5d 63 75 72 50 6f 73 20 |ecordset|]curPos |
|00005c90| 3d 20 22 45 4f 46 22 0d | 0a 65 6e 64 20 69 66 02 |= "EOF".|.end if.|
|00005ca0| 00 3e 80 05 00 00 00 13 | 52 65 63 6f 72 64 20 4e |.>......|Record N|
|00005cb0| 75 6d 62 65 72 20 54 6f | 6b 65 6e 00 00 00 00 08 |umber To|ken.....|
|00005cc0| 00 06 00 00 00 52 00 45 | 00 43 00 00 00 00 00 00 |.....R.E|.C......|
|00005cd0| 00 00 00 00 00 00 3e 80 | 05 00 00 00 13 54 6f 74 |......>.|.....Tot|
|00005ce0| 61 6c 20 52 65 63 6f 72 | 64 73 20 54 6f 6b 65 6e |al Recor|ds Token|
|00005cf0| 00 00 00 00 08 00 06 00 | 00 00 54 00 4f 00 54 00 |........|..T.O.T.|
|00005d00| 00 00 00 00 00 00 00 00 | 00 00 00 13 44 61 74 61 |........|....Data|
|00005d10| 62 61 73 65 20 6e 61 76 | 69 67 61 74 69 6f 6e 01 |base nav|igation.|
|00005d20| 00 0f 2a 65 12 28 83 d2 | 11 80 52 00 10 4b d3 38 |..*e.(..|..R..K.8|
|00005d30| d1 00 00 00 00 04 00 00 | 00 01 00 00 00 01 00 0b |........|........|
|00005d40| 80 04 00 00 00 06 53 65 | 72 76 65 72 01 00 00 00 |......Se|rver....|
|00005d50| 01 00 00 00 2e 5b 52 65 | 63 6f 72 64 73 65 74 5d |.....[Re|cordset]|
|00005d60| 63 75 72 50 6f 73 20 3d | 20 30 0d 0a 5b 52 65 63 |curPos =| 0..[Rec|
|00005d70| 6f 72 64 73 65 74 5d 72 | 65 63 43 6f 75 6e 74 20 |ordset]r|ecCount |
|00005d80| 3d 20 30 f1 25 4e d5 cc | 84 d2 11 80 54 00 10 4b |= 0.%N..|....T..K|
|00005d90| d3 38 d1 01 00 00 00 24 | 33 37 37 41 43 34 33 30 |.8.....$|377AC430|
|00005da0| 2d 36 32 31 31 2d 31 31 | 44 32 2d 38 31 31 37 2d |-6211-11|D2-8117-|
|00005db0| 30 30 36 30 30 38 43 38 | 36 43 32 35 03 33 2e 30 |006008C8|6C25.3.0|
|00005dc0| ff 96 05 56 31 30 5f 33 | 30 0d 0a 44 65 73 63 72 |...V10_3|0..Descr|
|00005dd0| 69 70 74 69 6f 6e 3a 0d | 0a 54 68 69 73 20 69 6e |iption:.|.This in|
|00005de0| 74 65 72 61 63 74 69 6f | 6e 20 72 65 70 6c 61 63 |teractio|n replac|
|00005df0| 65 73 20 74 68 65 20 74 | 6f 6b 65 6e 73 20 69 6e |es the t|okens in|
|00005e00| 20 61 20 74 65 78 74 20 | 65 6c 65 6d 65 6e 74 20 | a text |element |
|00005e10| 77 69 74 68 20 74 68 65 | 20 52 65 63 6f 72 64 20 |with the| Record |
|00005e20| 4e 75 6d 62 65 72 20 76 | 61 6c 75 65 20 61 6e 64 |Number v|alue and|
|00005e30| 20 74 68 65 20 54 6f 74 | 61 6c 20 4e 75 6d 62 65 | the Tot|al Numbe|
|00005e40| 72 20 6f 66 20 52 65 63 | 6f 72 64 73 20 69 6e 20 |r of Rec|ords in |
|00005e50| 74 68 65 20 52 65 63 6f | 72 64 73 65 74 2e 0d 0a |the Reco|rdset...|
|00005e60| 0d 0a 50 61 72 61 6d 65 | 74 65 72 73 3a 0d 0a 52 |..Parame|ters:..R|
|00005e70| 65 63 6f 72 64 20 4e 75 | 6d 62 65 72 20 54 6f 6b |ecord Nu|mber Tok|
|00005e80| 65 6e 20 3d 20 74 68 65 | 20 74 6f 6b 65 6e 20 69 |en = the| token i|
|00005e90| 6e 20 74 68 65 20 74 65 | 78 74 20 65 6c 65 6d 65 |n the te|xt eleme|
|00005ea0| 6e 74 20 74 6f 20 72 65 | 70 72 65 73 65 6e 74 20 |nt to re|present |
|00005eb0| 74 68 65 20 63 75 72 72 | 65 6e 74 20 72 65 63 6f |the curr|ent reco|
|00005ec0| 72 64 20 69 6e 20 74 68 | 65 20 72 65 63 6f 72 64 |rd in th|e record|
|00005ed0| 73 65 74 20 0d 0a 54 6f | 74 61 6c 20 52 65 63 6f |set ..To|tal Reco|
|00005ee0| 72 64 73 20 54 6f 6b 65 | 6e 20 3d 20 74 68 65 20 |rds Toke|n = the |
|00005ef0| 74 6f 6b 65 6e 20 69 6e | 20 74 68 65 20 74 65 78 |token in| the tex|
|00005f00| 74 20 65 6c 65 6d 65 6e | 74 20 74 6f 20 72 65 70 |t elemen|t to rep|
|00005f10| 72 65 73 65 6e 74 20 74 | 68 65 20 74 6f 74 61 6c |resent t|he total|
|00005f20| 20 6e 75 6d 62 65 72 20 | 6f 66 20 72 65 63 6f 72 | number |of recor|
|00005f30| 64 73 20 69 6e 20 74 68 | 65 20 52 65 63 6f 72 64 |ds in th|e Record|
|00005f40| 73 65 74 0d 0a 0d 0a 54 | 79 70 69 63 61 6c 20 50 |set....T|ypical P|
|00005f50| 61 72 74 69 63 69 70 61 | 6e 74 73 3a 0d 0a 5b 52 |articipa|nts:..[R|
|00005f60| 65 63 6f 72 64 73 65 74 | 5d 20 2d 20 61 20 52 65 |ecordset|] - a Re|
|00005f70| 63 6f 72 64 73 65 74 0d | 0a 5b 54 65 78 74 20 45 |cordset.|.[Text E|
|00005f80| 6c 65 6d 65 6e 74 5d 20 | 2d 20 74 68 65 20 74 65 |lement] |- the te|
|00005f90| 78 74 20 65 6c 65 6d 65 | 6e 74 20 74 68 61 74 20 |xt eleme|nt that |
|00005fa0| 68 61 73 20 6f 6e 65 20 | 6f 72 20 6d 6f 72 65 20 |has one |or more |
|00005fb0| 6f 66 20 74 68 65 20 61 | 62 6f 76 65 20 74 6f 6b |of the a|bove tok|
|00005fc0| 65 6e 73 20 69 6e 20 69 | 74 2e 0d 0a 0d 0a 45 78 |ens in i|t.....Ex|
|00005fd0| 61 6d 70 6c 65 3a 20 59 | 6f 75 20 63 6f 75 6c 64 |ample: Y|ou could|
|00005fe0| 20 68 61 76 65 20 61 20 | 74 65 78 74 20 65 6c 65 | have a |text ele|
|00005ff0| 6d 65 6e 74 20 6f 6e 20 | 74 68 65 20 44 65 74 61 |ment on |the Deta|
|00006000| 69 6c 73 20 50 61 67 65 | 20 6f 66 20 79 6f 75 72 |ils Page| of your|
|00006010| 20 44 61 74 61 20 46 6f | 72 6d 20 41 70 70 20 20 | Data Fo|rm App |
|00006020| 77 69 74 68 20 74 68 65 | 20 76 61 6c 75 65 20 27 |with the| value '|
|00006030| 5b 58 5d 20 6f 66 20 5b | 4e 5d 27 20 69 6e 20 69 |[X] of [|N]' in i|
|00006040| 74 2e 20 20 41 66 74 65 | 72 20 61 70 70 6c 79 69 |t. Afte|r applyi|
|00006050| 6e 67 20 74 68 69 73 20 | 63 6f 6e 74 72 61 63 74 |ng this |contract|
|00006060| 20 74 6f 20 74 68 65 20 | 74 65 78 74 20 65 6c 65 | to the |text ele|
|00006070| 6d 65 6e 74 20 61 6e 64 | 20 74 68 65 20 52 65 63 |ment and| the Rec|
|00006080| 6f 72 64 73 65 74 20 79 | 6f 75 20 77 69 6c 6c 20 |ordset y|ou will |
|00006090| 73 65 65 20 74 68 65 20 | 66 6f 6c 6c 6f 77 69 6e |see the |followin|
|000060a0| 67 20 77 68 65 6e 20 62 | 72 6f 77 73 69 6e 67 20 |g when b|rowsing |
|000060b0| 74 68 69 73 20 70 61 67 | 65 2e 20 20 54 68 65 20 |this pag|e. The |
|000060c0| 66 69 72 73 74 20 74 69 | 6d 65 20 79 6f 75 20 67 |first ti|me you g|
|000060d0| 6f 20 74 6f 20 74 68 65 | 20 70 61 67 65 2c 20 74 |o to the| page, t|
|000060e0| 68 65 20 74 65 78 74 20 | 65 6c 65 6d 65 6e 74 20 |he text |element |
|000060f0| 77 69 6c 6c 20 73 61 79 | 20 22 31 20 6f 66 20 31 |will say| "1 of 1|
|00006100| 30 32 22 20 69 66 20 74 | 68 65 72 65 20 61 72 65 |02" if t|here are|
|00006110| 20 31 30 32 20 72 65 63 | 6f 72 64 73 20 69 6e 20 | 102 rec|ords in |
|00006120| 74 68 65 20 52 65 63 6f | 72 64 73 65 74 2e 20 20 |the Reco|rdset. |
|00006130| 49 66 20 79 6f 75 20 63 | 6c 69 63 6b 20 74 68 65 |If you c|lick the|
|00006140| 20 4e 65 78 74 20 62 75 | 74 74 6f 6e 2c 20 74 68 | Next bu|tton, th|
|00006150| 65 20 74 65 78 74 20 65 | 6c 65 6d 65 6e 74 20 77 |e text e|lement w|
|00006160| 69 6c 6c 20 73 61 79 20 | 22 32 20 6f 66 20 31 30 |ill say |"2 of 10|
|00006170| 32 22 2e 20 20 49 66 20 | 79 6f 75 20 61 72 65 20 |2". If |you are |
|00006180| 6f 6e 20 74 68 65 20 6c | 61 73 74 20 72 65 63 6f |on the l|ast reco|
|00006190| 72 64 20 6f 66 20 74 68 | 65 20 52 65 63 6f 72 64 |rd of th|e Record|
|000061a0| 73 65 74 2c 20 28 69 2e | 65 2e 20 22 31 30 32 20 |set, (i.|e. "102 |
|000061b0| 6f 66 20 31 30 32 22 29 | 20 61 6e 64 20 63 6c 69 |of 102")| and cli|
|000061c0| 63 6b 20 74 68 65 20 4e | 65 78 74 20 62 75 74 74 |ck the N|ext butt|
|000061d0| 6f 6e 20 74 68 65 20 74 | 65 78 74 20 65 6c 65 6d |on the t|ext elem|
|000061e0| 65 6e 74 20 77 69 6c 6c | 20 62 65 20 62 6c 61 6e |ent will| be blan|
|000061f0| 6b 65 64 20 6f 75 74 2e | 0d 0a 0d 0a 4e 6f 74 65 |ked out.|....Note|
|00006200| 3a 20 69 74 20 69 73 20 | 69 6d 70 6f 72 74 61 6e |: it is |importan|
|00006210| 74 20 74 68 61 74 20 74 | 68 69 73 20 63 6f 6e 74 |t that t|his cont|
|00006220| 72 61 63 74 20 62 65 20 | 65 78 65 63 75 74 65 64 |ract be |executed|
|00006230| 20 6f 6e 20 74 68 65 20 | 52 65 63 6f 72 64 73 65 | on the |Recordse|
|00006240| 74 20 41 46 54 45 52 20 | 61 6e 79 20 66 69 6c 74 |t AFTER |any filt|
|00006250| 65 72 73 20 68 61 76 65 | 20 62 65 65 6e 20 61 70 |ers have| been ap|
|00006260| 70 6c 69 65 64 20 74 6f | 20 74 68 65 20 52 65 63 |plied to| the Rec|
|00006270| 6f 72 64 73 65 74 2e 20 | 20 59 6f 75 20 63 61 6e |ordset. | You can|
|00006280| 20 64 65 63 69 64 65 20 | 74 68 65 20 6f 72 64 65 | decide |the orde|
|00006290| 72 20 69 6e 20 77 68 69 | 63 68 20 74 68 65 20 63 |r in whi|ch the c|
|000062a0| 6f 6e 74 72 61 63 74 73 | 20 61 72 65 20 65 78 65 |ontracts| are exe|
|000062b0| 63 75 74 65 64 20 62 79 | 20 72 69 67 68 74 2d 63 |cuted by| right-c|
|000062c0| 6c 69 63 6b 69 6e 67 20 | 6f 6e 20 74 68 65 20 52 |licking |on the R|
|000062d0| 65 63 6f 72 64 73 65 74 | 20 69 63 6f 6e 20 61 6e |ecordset| icon an|
|000062e0| 64 20 73 65 6c 65 63 74 | 69 6e 67 0d 0a 22 41 73 |d select|ing.."As|
|000062f0| 73 69 67 6e 65 64 20 49 | 6e 74 65 72 61 63 74 69 |signed I|nteracti|
|00006300| 6f 6e 73 20 28 6f 72 64 | 65 72 65 64 29 22 20 61 |ons (ord|ered)" a|
|00006310| 6e 64 20 74 68 65 6e 20 | 64 72 61 67 67 69 6e 67 |nd then |dragging|
|00006320| 20 74 68 65 20 69 6e 74 | 65 72 61 63 74 69 6f 6e | the int|eraction|
|00006330| 73 20 74 6f 20 74 68 65 | 20 6f 72 64 65 72 20 79 |s to the| order y|
|00006340| 6f 75 20 77 61 6e 74 20 | 74 68 65 6d 20 74 6f 20 |ou want |them to |
|00006350| 61 70 70 65 61 72 2e 0d | 0a |appear..|. |
+--------+-------------------------+-------------------------+--------+--------+
